Tour
About Us
Meta
Loading…
current community
Stack Exchange
chat
Meta Stack Exchange
your communities
Sign up
or
log in
to customize your list.
more stack exchange communities
company blog
Log in
Stack Exchange
All Sites
Top Users
Digests
Erwin Brandstetter
Vienna, Austria
Database expert.
top
accounts
reputation
activity
subscriptions
Top Questions
40
votes
USING construct in JOIN clause can introduce optimization barriers in certain cases?
postgresql
performance
optimization
join
select
asked Apr 12, 2012 at 8:06
dba.stackexchange.com
28
votes
"Recheck Cond:" line in query plans with a bitmap index scan
postgresql
index
postgresql-9.4
query-plan
asked Jul 8, 2015 at 0:25
dba.stackexchange.com
22
votes
Syntax highlighting: <!-- language: lang-none --> does not seem to work for block quote
bug
code-formatting
syntax-highlighting
markdown-rendering
asked Sep 7, 2015 at 15:45
meta.stackexchange.com
19
votes
Naming conflict between function parameter and result of JOIN with USING clause
postgresql
join
plpgsql
parameter
naming-convention
asked Jul 2, 2015 at 23:54
dba.stackexchange.com
18
votes
PostgreSQL functions returning void
postgresql
stored-procedures
null
plpgsql
void
asked Nov 30, 2011 at 1:15
stackoverflow.com
15
votes
Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
sql
postgresql
constraints
postgresql-9.1
asked Apr 5, 2012 at 16:19
stackoverflow.com
14
votes
Why is code excluded from phrase search?
bug
search
exact-phrase
asked May 17, 2017 at 19:27
meta.stackexchange.com
14
votes
Description page for the "Edit questions and answers" privilege needs an edit
bug
status-completed
stackoverflow
privileges
asked Oct 10, 2011 at 6:19
meta.stackexchange.com
14
votes
Why *not* ERROR: index row size xxxx exceeds maximum 2712 for index "foo"?
postgresql
index
size
limits
asked Sep 8, 2018 at 15:56
dba.stackexchange.com
12
votes
Surprising results for data types with type modifier
postgresql
datatypes
cte
debugging
cast
asked Sep 26, 2015 at 0:36
dba.stackexchange.com
1
2
3
4
next
Top Answers
1713
Select first row in each GROUP BY group?
stackoverflow.com
1225
Insert text with single quotes in PostgreSQL
stackoverflow.com
1049
PostgreSQL error: Fatal: role "username" does not exist
stackoverflow.com
595
Create unique constraint with null columns
stackoverflow.com
583
Select rows which are not present in other table
stackoverflow.com
507
Fast way to discover the row count of a table in PostgreSQL
stackoverflow.com
489
Best way to check for "empty or null value"
stackoverflow.com
464
Are PostgreSQL column names case-sensitive?
stackoverflow.com
454
PostgreSQL create table if not exists
stackoverflow.com
453
Check if value exists in Postgres array
stackoverflow.com
450
PostgreSQL Crosstab Query
stackoverflow.com
438
How to implement a many-to-many relationship in PostgreSQL?
stackoverflow.com
437
PostgreSQL: Give all permissions to a user on a PostgreSQL database
stackoverflow.com
416
How do I (or can I) SELECT DISTINCT on multiple columns?
stackoverflow.com
403
How to check if a table exists in a given schema
stackoverflow.com
397
How to use RETURNING with ON CONFLICT in PostgreSQL?
stackoverflow.com
394
Concatenate multiple result rows of one column into one, group by another column
stackoverflow.com
392
Ignoring time zones altogether in Rails and PostgreSQL
stackoverflow.com
390
IN vs ANY operator in PostgreSQL
stackoverflow.com
373
PostgreSQL LIKE query performance variations
stackoverflow.com
352
Query a parameter (postgresql.conf setting) like "max_connections"
stackoverflow.com
348
How to concatenate columns in a Postgres SELECT?
stackoverflow.com
346
Query for array elements inside JSON type
stackoverflow.com
331
Best way to select random rows PostgreSQL
stackoverflow.com
331
Run a query with a LIMIT/OFFSET and also get the total number of rows
stackoverflow.com
331
What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
stackoverflow.com
295
Does PostgreSQL support "accent insensitive" collations?
stackoverflow.com
281
Postgres manually alter sequence
stackoverflow.com
276
Select first row in each GROUP BY group?
stackoverflow.com
259
Calculating and saving space in PostgreSQL
stackoverflow.com
1
2
3
4
5
…
10
next
Stack Exchange works best with JavaScript enabled