Erwin Brandstetter

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

ERROR: query has no destination for result data
Selecting table of properties as columns
Is it possible to tokenize text in PL/PGSQL using regular expressions?
Renumber reference variables in text columns
Adding unique constraint for null column returns error
Insert to table from set returning function with parameters
UNION and ORDER BY issue in MySQL
Multiple array_agg() calls in a single query
Optimistic Lock in UPDATE query
DISTINCT INNER JOIN slow