Clodoaldo Neto

Brasilia, Brazil

http://google.com/+ClodoaldoPintoNeto

top accounts reputation activity subscriptions

SQL Server equivalent of PostgreSQL distinct on ()

sql sql-server sql-server-2008 asked Apr 27, 2011 at 18:36

stackoverflow.com

29 votes

case when null evaluates to false

postgresql asked Mar 14, 2013 at 18:18

stackoverflow.com

22 votes

Index not used with = ANY() but used with IN

postgresql index optimization postgresql-9.4 query-plan asked Jan 6, 2016 at 17:48

dba.stackexchange.com

20 votes

Why is ' 2' > '10'?

sql postgresql collation asked Aug 13, 2011 at 22:55

stackoverflow.com

16 votes

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

postgresql upgrade asked Sep 18, 2013 at 14:49

dba.stackexchange.com

15 votes

SELinux preventing Apache from writing to a file

centos redhat apache-2.4 selinux centos7 asked Sep 5, 2014 at 19:44

serverfault.com

13 votes

Disk file effects of delete and vacuum

postgresql partitioning delete storage vacuum asked Feb 24, 2012 at 20:57

dba.stackexchange.com

11 votes

How to prevent inserts in the parent table?

postgresql database-design inheritance triggers foreign-key-relationship asked Mar 3, 2012 at 11:32

stackoverflow.com

10 votes

a:not(a:not([href])) selector

jquery jquery-events asked Jul 26, 2012 at 19:49

stackoverflow.com

10 votes

Open emacs in a terminal when editing crontab

bash cron emacs asked Aug 6, 2011 at 21:34

unix.stackexchange.com

Top Answers

756

List tables in a PostgreSQL schema

stackoverflow.com

429

In Postgresql, force unique on combination of two columns

stackoverflow.com

403

Export specific rows from a PostgreSQL table as INSERT SQL script

stackoverflow.com

397

Datetime equal or greater than today in MySQL

stackoverflow.com

336

Postgres: Distinct but only for one column

stackoverflow.com

230

psycopg2: insert multiple rows with one query

stackoverflow.com

175

Grouping timestamps by day, not by time

stackoverflow.com

168

Select hardcoded values without table

stackoverflow.com

136

What is the difference between `->>` and `->` in Postgres SQL?

stackoverflow.com

135

Conditional INSERT INTO statement in postgres

stackoverflow.com

121

How to join only one row in joined table with postgres?

stackoverflow.com

120

How can I generate big data sample for Postgresql using generate_series and random?

stackoverflow.com

Copy a few of the columns of a csv file into a table

stackoverflow.com

Insert if not exists, else return id in postgresql

stackoverflow.com

How to estimate the size of one column in a Postgres table?

stackoverflow.com

How to see the CREATE VIEW code for a view in PostgreSQL?

stackoverflow.com

Python psycopg2 timeout

stackoverflow.com

PostgreSQL: NULL value in foreign key column

stackoverflow.com

Reset auto increment counter in postgres

stackoverflow.com

Postgresql delete old rows on a rolling basis?

stackoverflow.com

Postgresql: backup all table structures but only a few data table

stackoverflow.com

postgres: create table in database from the command line

stackoverflow.com

PostgreSQL: Sub-select inside insert

stackoverflow.com

Function with SQL query has no destination for result data

stackoverflow.com

issue with string_agg with distinct in postgres

stackoverflow.com

PostgreSQL UUID type performance

stackoverflow.com

Insert Python Dictionary using Psycopg2

stackoverflow.com

Getting date with timezone offset

stackoverflow.com

Getting date list in a range in PostgreSQL

stackoverflow.com

How to match not null + not empty?

stackoverflow.com