Patrick

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

Change composite primary key column order, avoid exposing table without primary key
Change PostgreSQL date language from request
UUID SHORT() for PostGres
Optimization of search on concatenated firstname and lastname in PostgreSQL
Which GEO implementation to use for millions of points
mysql FIND_IN_SET equivalent to postgresql
PostgreSQL: How to store UUID value?
SQL - sort alphabetically for strings within a column
Postgresql: detecting which foreign key triggered the "on before delete" trigger
How to combine DISTINCT and ORDER BY in array_agg of jsonb values in postgresSQL