Patrick

Patrick has asked 9 questions and find answers to 193 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

How to aggregate an array of JSON objects with Postgres?
Pass column name to a function
Most efficient way to find points within a certain radius from a given point
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?