Immutable pure-SQL timestamp->epoch conversion
postgresql-12
PeterVandivier
PeterVandivier
7
Yes, you can: just convert to `timestamp` at UTC. This is not what you might expect.
Jack Douglas
Why does only one update work in this query?
postgresql-12
Jack Douglas
Jack Douglas
6
It [is documented](https://www.postgresql.org/docs/12/queries-with.html#QUERIES-WITH-MODIFYING) that this is not supported for data-modifying statements in `with` clauses:
Jack Douglas
Why does my query not insert any records
postgresql-12
Anonymous
Anonymous
3
`SAMPLE` is a different table from `"SAMPLE"`. PostgreSQL lower-cases unquoted table names to conform (its interpretation of) to the SQL standard.
PeterVandivier
How do you insert rows into mutually-referencing tables in an SQL function?
postgresql-12
Jack Douglas
Jack Douglas
5
I'm not sure this is a sensible general solution as I suspect it may cause concurrency issues, but if you choose a dummy value that will never be present in the table you can insert that, and then update it away again, in a pure `sql` function:
Jack Douglas
Split table based on data with duplicate IDs
postgresql-11
kha
kha
4
You can use [`EXISTS`](https://www.postgresql.org/docs/current/functions-subquery.html#FUNCTIONS-SUBQUERY-EXISTS) to get all in a single query:
Erwin Brandstetter
2
There are lots of ways to do this. Here is a solution using the windowing function version of `count`:
Jack Douglas
Merge/combine values within a group
postgresql-9.5
kha
kha
1
You need several steps to do this:
Jack Douglas
