Nice postgres tips

[Bernd.N]

For those who are not yet postgres gurus, this link might be interesting with more than 100 postgres tips:
https://til.hashrocket.com/sql

They also have a nice podcast site
https://www.pgcasts.com/

[marco.rossi]

Thank you for sharing it

[Bernd.N]

Here is another site, it contains interesting examples for aggregates and recursive SELECTs.
https://pgexercises.com/questions/aggregates/

There is a Show button on left lower site which shows the answers.

Also interesting:
http://postgresguide.com

And here, a trigger is explained quite understandingly:
http://www.tutorialspoint.com/postgresql/postgresql_triggers.htm

[swingman]

Great stuff. Thanks for sharing!

[Manolo_Etec]

thanks!!!