Erwin Brandstetter

Vienna, Austria

Age: 93

top accounts reputation activity favorites subscriptions

USING construct in JOIN clause can introduce optimization barriers in certain cases?

postgresql performance join select asked Apr 12 '12 at 8:06

dba.stackexchange.com

14 votes

Description page for the “Edit questions and answers” privilege needs an edit

bug status-completed stackoverflow privileges asked Oct 10 '11 at 6:19

meta.stackoverflow.com

13 votes

Organize tags for SQL key words

discussion tags sql asked Jul 28 '12 at 4:01

meta.stackoverflow.com

11 votes

Wrong tag synonym: psql -> PostgreSQL

feature-request support status-completed stackoverflow tag-synonyms asked Jul 4 '12 at 20:10

meta.stackoverflow.com

8 votes

Contradictory information for Copy Editor progress

bug status-bydesign badges review editing-badges asked Jan 20 '12 at 1:24

meta.stackoverflow.com

7 votes

Create a new tag for a piece of software with limited user base?

discussion support tags asked Sep 30 '11 at 18:54

meta.stackoverflow.com

7 votes

Mass fix for outdated links to PostgreSQL development docs

discussion hyperlinks clean-up asked Dec 7 '11 at 7:34

meta.stackoverflow.com

6 votes

How to get to my answer after author of question voluntarily removed it

discussion feature-request support asked Sep 20 '11 at 23:45

meta.stackoverflow.com

5 votes

Best way to reference the PostgreSQL manual?

discussion editing hyperlinks asked Oct 7 '11 at 19:38

meta.stackoverflow.com

5 votes

Tag synonyms for pgAdmin

support status-completed tags tag-synonyms asked Mar 19 '12 at 14:36

meta.stackoverflow.com

Top Answers

Select first row in each GROUP BY group?

stackoverflow.com

How to filter SQL results in a has-many-through relation

stackoverflow.com

Ignoring timezones altogether in Rails and PostgreSQL

stackoverflow.com

PostgreSQL create table if not exists

stackoverflow.com

How do I (or can I) SELECT DISTINCT on multiple columns (postgresql)?

stackoverflow.com

How do you do date math that ignores the year?

stackoverflow.com

How do I query using fields inside the new PostgreSQL JSON datatype?

stackoverflow.com

PostgreSQL: running count of rows for a query 'by minute'

stackoverflow.com

PostgreSQL Crosstab Query

stackoverflow.com

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

dba.stackexchange.com

Calculating and saving space in Postgresql

stackoverflow.com

Auto increment SQL function

stackoverflow.com

PostgreSQL error: Fatal: role “username” does not exist

stackoverflow.com

Error when creating unaccent extension on PostgreSQL

stackoverflow.com

Working of indexes in PostgreSQL

dba.stackexchange.com

PostgreSQL multi-column unique constraint and NULL values

dba.stackexchange.com

Concatenate strings in Oracle SQL without a space in between?

stackoverflow.com

Query a parameter (postgresql.conf setting) like “max_connections”

stackoverflow.com

Best way to select random rows PostgreSQL

stackoverflow.com

Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?

stackoverflow.com

Insert varchar with single quotes in postgresql

stackoverflow.com

insert with dynamic table name in trigger function

stackoverflow.com

Create unique constraint with null columns

stackoverflow.com

How to create table inside specific schema by default in Postgres?

stackoverflow.com

PostgreSQL LIKE query performance variations

stackoverflow.com

PostgreSQL versus MySQL for EAV structures storage

dba.stackexchange.com

Is a composite index also good for queries on the first field?

dba.stackexchange.com

Return a value if no record is found

stackoverflow.com

Best way to get result count before LIMIT was applied in PHP/PostgreSQL

stackoverflow.com

PL/pgSQL checking if a row exists - SELECT INTO boolean

stackoverflow.com