User Erwin Brandstetter - Stack Overflow

18 votes

1 answer

20k views

PostgreSQL functions returning void

asked Nov 30, 2011 at 1:15

15 votes

2 answers

21k views

Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?

asked Apr 5, 2012 at 16:19

14 votes

3 answers

5k views

What is easier to read in EXISTS subqueries? [closed]

asked Oct 10, 2011 at 8:24

9 votes

2 answers

3k views

Function executes faster without STRICT modifier?

asked Dec 10, 2011 at 7:43

7 votes

3 answers

3k views

Normalize array subscripts so they start with 1

asked Aug 17, 2012 at 18:52

6 votes

2 answers

3k views

Time zone names with identical properties yield different result when applied to timestamp

asked Aug 20, 2012 at 17:50

6 votes

1 answer

4k views

NULL emements lost when casting result of unnest()

asked May 9, 2013 at 0:38

6 votes

1 answer

3k views

Get the count of rows from a COPY command

asked May 17, 2013 at 13:35

6 votes

3 answers

10k views

SQL Server: collect values in an aggregation temporarily and re-use in the same query

asked Nov 13, 2011 at 3:52

6 votes

2 answers

12k views

Make SQLAlchemy COMMIT instead of ROLLBACK after a SELECT query

asked Sep 26, 2011 at 18:31

0 votes

4 answers

3k views

regexp_matches() returns two matches for $ (end of string)

asked Aug 12, 2013 at 14:06

Collectives™ on Stack Overflow

11 Questions

PostgreSQL functions returning void

Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?

What is easier to read in EXISTS subqueries? [closed]

Function executes faster without STRICT modifier?

Normalize array subscripts so they start with 1

Time zone names with identical properties yield different result when applied to timestamp

NULL emements lost when casting result of unnest()

Get the count of rows from a COPY command

SQL Server: collect values in an aggregation temporarily and re-use in the same query

Make SQLAlchemy COMMIT instead of ROLLBACK after a SELECT query

regexp_matches() returns two matches for $ (end of string)