Erwin Brandstetter

less info
meta site favicon meta user | stack exchange network profile network profile
8,687 reputation
1137
bio website
location Vienna, Austria
age 93
visits member for 1 year, 7 months
seen 3 hours ago
stats profile views 338

208 Answers

newest activity votes
4
Locking issue with concurrent DELETE / INSERT in PostgreSQL
4
query discrepancies on very large postgres table
4
Lookup table for a one-to-many relationship
4
Bug in PL/pgSQL function creation
4
Dynamic access to record column in plpgsql function
4
How is LIKE implemented?
4
How to concatenate psql variables?
4
Most efficient way to add a serial column to a huge table
4
How to view data in pgAdmin III
4
pull records that are inactive
4
How can I write a proper query to JOIN all of these tables without duplicates?
4
Postgres multiple joins slow query, how to store default child record
4
How to get actually allocated tablespace size by each postgres database?
4
SQL Query Formatter
3
“Truncate” or “Delete/Vacuum Full” for deleting some of the table rows
3
How can I benchmark a PostgreSQL query?
3
Postgres: count(*) vs count(id)
3
PostgreSQL and default Schemas
3
How do I create an index to speed up an aggregate LIKE query on an expression in postgres 8.4?
3
Postgresql querying trends
3
Correct use of VOLATILE COST (and ROWS) indications in Postgresql stored procedure
3
What fillfactor for caching table?
3
Declare variable of table type in PL/pgSQL
3
How to pass a table type with an array field to a function in postgresql
3
Use GIN to index bit strings
3
PostgreSQL 8.4 no levenshtein fuzzymatching?
3
How to prevent query execution after exiting the \e editor in psql?
3
“AT TIME ZONE” with zone name PostgreSQL bug?
3
GRANT privileges to table elements
3
Running a CTE query in a loop using PL/pgSQL
1 2 3 4 5 … 7