Patrick

Patrick has asked 9 questions and find answers to 165 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 limit the length of an array in PostgreSQL?
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