Stack Exchange
log in
chat
meta
about
Stack Exchange
All Sites
Hot Questions
Top Users
Newsletters
Blogs
Erwin Brandstetter
Vienna, Austria
Age: 93
top
accounts
reputation
activity
favorites
subscriptions
Top Questions
20
votes
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
1
2
next
Top Answers
60
Select first row in each GROUP BY group?
stackoverflow.com
41
How to filter SQL results in a has-many-through relation
stackoverflow.com
31
Ignoring timezones altogether in Rails and PostgreSQL
stackoverflow.com
29
PostgreSQL create table if not exists
stackoverflow.com
27
How do I (or can I) SELECT DISTINCT on multiple columns (postgresql)?
stackoverflow.com
26
How do you do date math that ignores the year?
stackoverflow.com
21
How do I query using fields inside the new PostgreSQL JSON datatype?
stackoverflow.com
19
PostgreSQL: running count of rows for a query 'by minute'
stackoverflow.com
19
PostgreSQL Crosstab Query
stackoverflow.com
18
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
dba.stackexchange.com
16
Calculating and saving space in Postgresql
stackoverflow.com
15
Auto increment SQL function
stackoverflow.com
15
PostgreSQL error: Fatal: role “username” does not exist
stackoverflow.com
14
Error when creating unaccent extension on PostgreSQL
stackoverflow.com
14
Working of indexes in PostgreSQL
dba.stackexchange.com
14
PostgreSQL multi-column unique constraint and NULL values
dba.stackexchange.com
13
Concatenate strings in Oracle SQL without a space in between?
stackoverflow.com
13
Query a parameter (postgresql.conf setting) like “max_connections”
stackoverflow.com
13
Best way to select random rows PostgreSQL
stackoverflow.com
13
Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?
stackoverflow.com
13
Insert varchar with single quotes in postgresql
stackoverflow.com
12
insert with dynamic table name in trigger function
stackoverflow.com
12
Create unique constraint with null columns
stackoverflow.com
12
How to create table inside specific schema by default in Postgres?
stackoverflow.com
12
PostgreSQL LIKE query performance variations
stackoverflow.com
12
PostgreSQL versus MySQL for EAV structures storage
dba.stackexchange.com
12
Is a composite index also good for queries on the first field?
dba.stackexchange.com
11
Return a value if no record is found
stackoverflow.com
11
Best way to get result count before LIMIT was applied in PHP/PostgreSQL
stackoverflow.com
11
PL/pgSQL checking if a row exists - SELECT INTO boolean
stackoverflow.com
1
2
3
4
5
…
8
next
Stack Exchange works best with JavaScript enabled