4. current community

    your communities

    more stack exchange communities

    company blog

Stack Exchange

Erwin Brandstetter

Vienna, Austria

Database expert.

top accounts reputation activity favorites subscriptions
Top Questions
32 votes

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

postgresql performance optimization join select asked Apr 12 '12 at 8:06
dba.stackexchange.com

19 votes

Syntax highlighting: <!-​- language: lang-none --> does not seem to work for block quote

bug code-formatting syntax-highlighting markdown-rendering asked Sep 7 '15 at 15:45
meta.stackexchange.com

16 votes

PostgreSQL functions returning void

postgresql stored-procedures null plpgsql void asked Nov 30 '11 at 1:15
stackoverflow.com

16 votes

“Recheck Cond:” line in query plans with a bitmap index scan

postgresql index postgresql-9.4 query-plan asked Jul 8 '15 at 0:25
dba.stackexchange.com

15 votes

Naming conflict between function parameter and result of JOIN with USING clause

postgresql join plpgsql parameter naming-convention asked Jul 2 '15 at 23:54
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.stackexchange.com

13 votes

Why is code excluded from phrase search?

bug search exact-phrase asked May 17 '17 at 19:27
meta.stackexchange.com

13 votes

Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?

postgresql constraints postgresql-9.1 asked Apr 5 '12 at 16:19
stackoverflow.com

12 votes

Inconsistencies in the rendering of lists

bug status-completed markdown markdown-rendering asked Nov 4 '14 at 1:39
meta.stackexchange.com

11 votes

Surprising results for data types with type modifier

postgresql datatypes cte debugging cast asked Sep 26 '15 at 0:36
dba.stackexchange.com

1 2 3

Top Answers
962
Select first row in each GROUP BY group?
stackoverflow.com

669
PostgreSQL error: Fatal: role “username” does not exist
stackoverflow.com

609
Insert text with single quotes in PostgreSQL
stackoverflow.com

322
Ignoring time zones altogether in Rails and PostgreSQL
stackoverflow.com

318
Create unique constraint with null columns
stackoverflow.com

316
How do I (or can I) SELECT DISTINCT on multiple columns?
stackoverflow.com

306
Select rows which are not present in other table
stackoverflow.com

279
PostgreSQL Crosstab Query
stackoverflow.com

256
Check if value exists in Postgres array
stackoverflow.com

251
PostgreSQL LIKE query performance variations
stackoverflow.com

227
How to check if a table exists in a given schema
stackoverflow.com

224
How to implement a many-to-many relationship in PostgreSQL?
stackoverflow.com

217
Best way to check for “empty or null value”
stackoverflow.com

213
Are PostgreSQL column names case-sensitive?
stackoverflow.com

213
How to concatenate columns in a Postgres SELECT?
stackoverflow.com

195
PostgreSQL create table if not exists
stackoverflow.com

191
Best way to select random rows PostgreSQL
stackoverflow.com

185
Give all the permissions to a user on a DB
stackoverflow.com

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

176
Fast way to discover the row count of a table in PostgreSQL
stackoverflow.com

170
Does PostgreSQL support “accent insensitive” collations?
stackoverflow.com

169
Calculating and saving space in PostgreSQL
stackoverflow.com

168
How do I query using fields inside the new PostgreSQL JSON datatype?
stackoverflow.com

167
Concatenate multiple result rows of one column into one, group by another column
stackoverflow.com

160
Query for array elements inside JSON type
stackoverflow.com

154
Optimizing queries on a range of timestamps (two columns)
dba.stackexchange.com

149
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
dba.stackexchange.com

149
Export specific rows from a PostgreSQL table as INSERT SQL script
stackoverflow.com

147
Postgres manually alter sequence
stackoverflow.com

141
How to use RETURNING with ON CONFLICT in PostgreSQL?
stackoverflow.com

1 2 3 4 5 … 10