Skip to main content
Nick Barnes's user avatar
Nick Barnes's user avatar
Nick Barnes's user avatar
Nick Barnes
  • Member for 14 years, 4 months
  • Last seen this week
  • Melbourne, Australia
126 votes
Accepted

Equivalence of from dual in PostgreSQL

104 votes
Accepted

ERROR: integer out of range on Postgresql

62 votes
Accepted

Postgres UPDATE with ORDER BY, how to do it?

44 votes

PostgreSQL column type conversion from bigint to bigserial

43 votes
Accepted

Postgresql fatal the database system is starting up - windows 10

39 votes
Accepted

Defining multi-line strings in psql

37 votes
Accepted

Postgres CREATE EXTENSION All Databases

32 votes
Accepted

Performance of NUMERIC type with high precisions and scales in PostgreSQL

29 votes
Accepted

PostgreSQL 9.3: Function is not unique error

29 votes
Accepted

How does postgresql lock tables when inserting and selecting?

28 votes
Accepted

Delphi passing parameters by reference or by value/copy

27 votes
Accepted

Can a Postgres Commit Exist in Procedure that has an Exception Block?

26 votes
Accepted

PostgreSQL Syntax error at or near FUNCTION on create trigger

26 votes

Postgres returns [null] instead of [] for array_agg of join table

24 votes
Accepted

SML: difference between type and datatype

22 votes
Accepted

How to copy a csv file from a url to Postgresql

21 votes
Accepted

Psycopg2 peer authentication for user postgres

21 votes
Accepted

Counter cache column in PostgreSQL

20 votes

What is the unit of PostgreSQL shared_buffers?

20 votes
Accepted

PostgreSQL - RETURNING INTO array

20 votes
Accepted

Suppressing "Notice: Relation exists" when using "CREATE ... IF NOT EXISTS"

19 votes
Accepted

Postgresql - Dump database with x tables - schema only but data from one table

18 votes
Accepted

PostgreSQL: deadlock detected SELECT FOR UPDATE in transaction

17 votes
Accepted

Default isolation level for transaction (@atomic) with Django and PostgreSQL

16 votes
Accepted

Remove curly braces from xpath output in Postgres

16 votes
Accepted

java string permutations and combinations lookup

15 votes
Accepted

PostgreSQL's Repeatable Read Allows Phantom Reads But its document says that it does not allow

15 votes
Accepted

Is it possible to define global variables in postgresql

14 votes
Accepted

How to avoid dead lock while using advisory locks in postgresql

14 votes

How to use IN clause with PreparedStatement in PostgreSQL

1
2 3 4 5
12