Erwin Brandstetter

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

dynamic query postgres
Deadlock when using SELECT FOR UPDATE with WHERE IN clause
PostgreSQL custom week number - first week containing Feb 1st
Retrieve last known value for each column of a row
Trigger with multiple WHEN conditions
Creating user with password from variables in anonymous block
PostgreSQL - Query Optimization
How to constrain that JSON/JSONB values in a column be completely different?
How to use generate_series() to generate a grid of values
Rank based on sequence of dates