Skip to main content
joanolo's user avatar
joanolo's user avatar
joanolo's user avatar
joanolo
  • Member for 7 years, 6 months
  • Last seen more than a week ago
39 votes
Accepted

Creating a UNIQUE constraint from a JSON object

37 votes
Accepted

Querying non-ASCII rows from Postgres

37 votes

Postgres Listen/Notify As Message Queue

21 votes
Accepted

(x IS NOT NULL) vs (NOT x IS NULL) in PostgreSQL

19 votes

Postgres: How is SET NOT NULL "more efficient" than CHECK constraint

18 votes
Accepted

Is it possible to set a composite NOT NULL constraint in PostgreSQL

16 votes
Accepted

PostgreSQL 9.6 column dropping and side-effects on SQL functions with CTEs

16 votes

How to check what Database Engine is installed on the DataBase server that I have acces to run queries on?

15 votes

How to execute multiple statement in PgAdmin 4 like we do in Sql Server/Oracle?

15 votes
Accepted

Multicolumn indexes and OR clause

15 votes
Accepted

Generic end date of quarter, PostgreSQL

14 votes
Accepted

psql: fatal database does not exist error

11 votes
Accepted

How can I speed-up my query on geo-location processes

11 votes
Accepted

PostgreSQL/PostGIS 9.6 broke my compound index

11 votes
Accepted

Getting the count and sum of distinct record from Postgres jsonb attribute

10 votes
Accepted

Database size reduced after backup on PostgreSQL 8.3 and restore in PostgreSQL 9.4

10 votes
Accepted

the REFERENCES privilege is only about creating a foreign key constraint? Practical use cases?

10 votes
Accepted

Kill connection in pgadmin4 Postgresql

8 votes
Accepted

Should i use subquery to limit table before a join?

8 votes
Accepted

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

8 votes

SQLite, ASCII A-Z Check Constraint

8 votes
Accepted

How to pivot rows into columns MySQL

8 votes
Accepted

How to speed up query with joins

8 votes
Accepted

Autoincrement vs composite primary key for a big table on innodb

8 votes
Accepted

Order by on two columns very slow compared to order by on a single column

7 votes

Separate month and year columns, or date with day always set to 1?

7 votes
Accepted

Getting the only updated field using a postgreSQL trigger?

7 votes

Is there anything wrong with linking two identical primary keys in two different tables?

7 votes
Accepted

Is there any way to prevent a PostgreSQL user to change his/her own password?

6 votes
Accepted

Proof that Inner Join is Commutative

1
2 3 4 5
10