Erwin Brandstetter

Erwin Brandstetter has asked 15 questions and find answers to 2054 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 to specify min and max digits for a bank account number?
Count the most recent number of consecutive rows with a null value
Select rows with a specific column greater than zero in some related rows
Select rows with most similar set of attributes
How to remove duplicates in combination of three columns in python with postgresql
Updating integer column from jsonb member fails with: column is of type integer but expression is of type jsonb
Why is this count query so slow?
How to get the values for every group of the top 3 types
Search and select from Postgres NOSQL / json data
Slow query after big INSERT in Postgres