Patrick

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

Windows: how can I set my PostgreSQL user to the superuser?
postgres + jsonb + get values of key from multidimentional array
How to write a group attribute using ncdf4?
Function with cursor in postgreSQL
Postgresql "update query returning *" with limit
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