Patrick

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

Postgresql function with if statement
Postgres jsonb array: query for non-empty intersection
How to insert to Postgresql geometry column
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