Skip to main content
Yanick Rochon's user avatar
Yanick Rochon's user avatar
Yanick Rochon's user avatar
Yanick Rochon
  • Member for 11 years
  • Last seen more than 1 year ago
59 votes
7 answers
174k views

Select columns inside json_agg

19 votes
1 answer
35k views

PostgreSQL : drop column from view

16 votes
1 answer
40k views

Postgres query to return JSON object keys as array

11 votes
1 answer
29k views

PostgreSQL and MONEY data type for currency values

9 votes
2 answers
7k views

Removing duplicate rows with two or more left join tables

5 votes
3 answers
3k views

Do not reject entire statement when deleting rows in batch

5 votes
2 answers
559 views

Update SQL n:n table with multiple associations

4 votes
3 answers
8k views

Custom sorting of a query

3 votes
2 answers
4k views

SELECT UNION from two views of the same table

1 vote
1 answer
2k views

Handling exceptions from inside a function

1 vote
1 answer
1k views

Postgres : Executing SELECT within a transaction does not return most recent rows

0 votes
1 answer
324 views

PostgreSQL : inconsistent result when using WHERE clause on VIEW

0 votes
1 answer
8k views

Compare only day / month / year portion of a timestamp field

0 votes
2 answers
2k views

Is inserting in a MySQL table with a Full-Text index really slow?