Erwin Brandstetter

Erwin Brandstetter has asked 15 questions and find answers to 1887 problems.

Stats

About

Database expert.

Erwin Brandstetter questions

Make SQLAlchemy COMMIT instead of ROLLBACK after a SELECT query
Get the count of rows from a COPY command
Function executes faster without STRICT modifier?
NULL emements lost when casting result of unnest()
Time zone names with identical properties yield different result when applied to timestamp
SQL Server: collect values in an aggregation temporarily and re-use in the same query
Normalize array subscripts for 1-dimensional array so they start with 1
What is easier to read in EXISTS subqueries? [closed]
Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
PostgreSQL functions returning void

Erwin Brandstetter answers

Select unique count of rows referenced
How can I sort the postgres column with certain special characters?
How to make ORDER SIBLINGS BY?
PostgreSQL Unique Constraint with Exclusions
Altering JSON column to INTEGER[] ARRAY
How to reduce the costs of an sql select with order by?
How to get definition/source code of an aggregate in PostgreSQL?
Is there any shortcut to declare several variables of the same type in plpgsql?
Putting timestamp in a COMMENT ON TABLE
LIKE query on elements of flat jsonb array