postgresql 学习 PL/pgSQL 的好资源？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1295520/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Good resources for learning PL/pgSQL?
提问by mikl
I've been looking around the net trying to find good resources for learning PostgreSQL's procedural programming language, PL/pgSQL.
我一直在网上寻找学习 PostgreSQL 过程编程语言 PL/pgSQL 的好资源。
So far the only thing I've managed to dig up is the tutorial in the PostgreSQL documentation. While that is good, I've been looking for something more in-depth. Can you recommend anything?
到目前为止，我唯一设法挖掘的是PostgreSQL 文档中的教程。虽然这很好，但我一直在寻找更深入的东西。你能推荐什么吗？
采纳答案by Greg Smith
The best free intro to use along the official docs is at PL/pgSQLand its associated trickspage of non-trivial examples, although the translation is a bit rough in spots. More useful examples can be found rooting through the snippetspage.
与官方文档一起使用的最佳免费介绍是在PL/pgSQL及其相关的非平凡示例技巧页面，尽管翻译在某些地方有点粗糙。更多有用的示例可以通过代码片段页面找到。
There are also decent chapters on PL/pgSQL inside "PostgreSQL Developer's Handbook" by Geschwinde/Schonig and "PostgreSQL" by Korry Douglas, both of which are a bit gentler intro to the language than the official docs. Those are both excellent general PostgreSQL books you might find useful for other reasons too.
Geschwinde/Schonig 的“PostgreSQL 开发人员手册”和 Korry Douglas 的“PostgreSQL”中也有关于 PL/pgSQL 的不错的章节，这两个章节比官方文档更温和地介绍了该语言。这些都是优秀的通用 PostgreSQL 书籍，您可能会因为其他原因而发现它们很有用。
回答by Greg Smith
I think that that best introduction are:
我认为最好的介绍是：
- the docs
- trying
- trying
- trying
- 文档
- 试
- 试
- 试
With steps 2 - 4, you can usually get a pretty good help on irc - #postgresql on irc.freenode.net, and mailing lists.
通过步骤 2 - 4，您通常可以在 irc - #postgresql on irc.freenode.net 和邮件列表上获得很好的帮助。
回答by Pavel Stehule
http://www.postgres.cz/index.php/PL/pgSQL_%28en%29
http://www.postgres.cz/index.php/PL/pgSQL_%28en%29
plpgsql is simple - and it is very similar to PL/SQL (from Oracle).
plpgsql 很简单 - 它与 PL/SQL（来自 Oracle）非常相似。
回答by Dimitrios Mistriotis
I think it because of the way postgreSQL is structured and developed, the best place to search for tutorials is the on-line documentation.
我认为这是因为 postgreSQL 的结构和开发方式，搜索教程的最佳位置是在线文档。
The problem here is that the documentation assumes that you know what you want to do, you know the concepts, but you don't know how. Therefore you need to add a general database book in the mix in case you want to dwell into the concepts.
这里的问题是文档假设你知道你想要做什么，你知道概念，但你不知道如何做。因此，您需要在组合中添加一本通用数据库书籍，以防您想深入了解这些概念。
That's my taste of postgreSQL so far. It is different than MySQL or SQLServer where there are thousands of resources available, but quantity is matched here with the quality of the documentation.
到目前为止，这就是我对 postgreSQL 的品味。它与 MySQL 或 SQLServer 不同，后者有数以千计的可用资源，但数量与文档质量相匹配。
