Erwin Brandstetter

less info
meta site favicon meta user | stack exchange network profile network profile
8,812 reputation
1238
bio website
location Vienna, Austria
age 93
visits member for 1 year, 7 months
seen 48 mins ago
stats profile views 344

210 Answers

newest activity votes
1
Postgres 9.2 select multiple specific rows in one query
2
Approaches for deleting unnecessary records from tables
4
“Truncate” or “Delete/Vacuum Full” for deleting some of the table rows
2
No way to set maximum retrieved rows in pgadmin query tool
1
String replace using concatenated strings from various columns
2
How to simplify a nested SELECT with PostgreSQL arrays?
3
How can I benchmark a PostgreSQL query?
7
PostgreSQL created a PostgreSQL user on mac. Is this necessary?
4
Select first row (grouping) + add aggregate function
10
For absolute performance, is SUM faster or COUNT?
1
Postgres - Schema information within Trigger?
1
PostgreSQL stored function that returns arbitrary resultset
5
Table for optional parent/child relationship
1
Referencing a Join table
4
Optimizing bulk update performance in Postgresql
2
Dropping a group of schemas with similar name patterns
3
Postgres: count(*) vs count(id)
1
Creating a PostgreSQL SERIAL column using pgAdmin3
1
Usage of COPY FROM STDIN in postgres
1
Summation query with complex grouping criteria
3
PostgreSQL and default Schemas
2
How to implement posts with “seen by” like facebook?
6
PostgreSQL Stored Procedure Performance
2
Optimizing queries on a range of timestamps (two columns)
3
How do I create an index to speed up an aggregate LIKE query on an expression in postgres 8.4?
2
Inner join using an array column
3
Postgresql querying trends
1
Comparing two tables for a UUID change and fix it
0
How to use array variable in query in PostgreSQL
1
Getting error while importing large data through csv
1 2 3 4 5 … 7