Skip to main content
Jasen's user avatar
Jasen's user avatar
Jasen's user avatar
Jasen
  • Member for 9 years, 2 months
  • Last seen more than a month ago
32 votes
Accepted

PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?

21 votes

What's the order of operations in PostgreSQL?

12 votes
Accepted

How to prevent asking for password when creating new database in PostgreSQL 10?

11 votes

Is there a way to insert multiple rows into a table with default values for all columns?

6 votes
Accepted

json_object_agg errors on null in field name

5 votes
Accepted

Select only the last record for multiple values

5 votes

How to auto-increment a serial column ON UPDATE?

5 votes
Accepted

Name of not null constraint is missing in error message

5 votes

Is there a way to connect to postgres when have error "sorry, too many clients already "?

5 votes
Accepted

Possible to drop table ignoring dependencies?

5 votes
Accepted

Indexing the condition lower(f) LIKE '%foo%'

5 votes

Advantages to column constraints over table constraints

5 votes

How to limit rows in PostgreSQL update statement

4 votes

Dangers in dropping all tables in a schema with CASCADE

4 votes

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

4 votes

How to prove the lack of implicit order in a database?

3 votes
Accepted

In BEFORE UPDATE TRIGGER, how do I prevent changing nothing but timestamp?

3 votes
Accepted

Postgres 12: declare a function as constant or immutable ignoring parameters?

3 votes

How to estimate the size of a PostgreSQL DB to be dumped through pg_dump

3 votes

Presto SQL: TO_UNIXTIME

3 votes
Accepted

Create 2D truth table from "cross product" of two tables via PostgreSQL view or function

3 votes
Accepted

Is there a way to obtain 'NaN' using only numbers?

3 votes

Performance of large transactions and concurrency?

3 votes

Distributing a single table across multiple disks of different performance?

3 votes
Accepted

Is there any string compaction option for PostgreSQL?

3 votes

Does a query with a primary key and foreign keys run faster than a query with just primary keys?

2 votes
Accepted

How to speed up simple query

2 votes

Will Postgres Deadlock on Single Update

2 votes
Accepted

Infinite scrolling with full text search in PostgreSQL

2 votes

Postgres 9.3 changes the standard_conforming_strings value

1
2 3 4 5