Patrick

Patrick has asked 9 questions and find answers to 190 problems.

Stats

About

Building PostgreSQL-based application for tropical forest information management.

Patrick questions

Reviewing defined row level security policies in PostgreSQL-9.5
How can I efficiently find the index of a value in a sorted array?
Retrieving all object privileges for specific role
Referencing current row in FILTER clause of window function

Patrick answers

Creating JDBCRealm with postgres driver
Postgresql LISTEN / NOTIFY recap
refactoring postgres join vs except
Using row data in pg_notify trigger as channel name?
Why is the column reference ambiguous in INNER JOIN, but not in NATURAL JOIN?
Multiple assignments in a single select
How to rename a PostgreSQL table by prefixing an underscore?
Can JOIN operations be ordered in a CTE? (PostgreSQL)
Postgres get first and last version for individual vendor
Postgresql trigger for all tables that include create date