Patrick

Patrick has asked 10 questions and find answers to 200 problems.

Stats

About

Building PostgreSQL-based application for tropical forest information management.

Patrick questions

Is it possible to align x axis title to a value of the axis?
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

Autoincrement attribute based on another attribute
How to get current date - two weeks date using Postgresql?
Postgresql - error returned more than one row from function
Postgres Unique JSON Array Aggregate Values
How can I get pg_regress?
Postgres COPY TO PROGRAM with dynamic command
How to automatically map view-columns to their original columns for inserting into source-tables?
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