Erwin Brandstetter

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

Regex to remove multiple characters
Why query in wrapped PLPGSQL function is much slower than itself?
how to select postgres rows where at least one json element matches some criteria?
How to import a CSV to postgresql that already has ID's assigned?
postgresql plpsql function with IF ELSE statement
Problems with group_by statement, sqlalchemy and postgresql
regexp_replace acts as if I've given it a global flag, but I have not
PostgreSQL regular expression
Sequential scan for column indexed with varchar_pattern_ops
How to show all dates from a certain date range in horizontal row?