Erwin Brandstetter

Erwin Brandstetter has asked 15 questions and find answers to 2001 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

How do I unnest an array inside a function?
PostgreSQL, SELECT CASE COALESCE
Update multiple values from an array with array_replace()
Correct order of Postgres maintenance
Counting distinct rows using recursive cte over non-distinct index
Will changing column from timestamp to timestamptz lock the table?
PostgreSQL INSERT or UPDATE values given a SELECT result after a trigger has been hit
Split comma separated values into target table with fixed number of columns
Postgres %% in function
Resample on time series data