Re: Do blocks support transaction control?

2022-09-24 Thread Laurenz Albe
On Fri, 2022-09-23 at 13:33 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/14/sql-do.html > Description: > > Apparently now DO blocks support COMMIT; - which make them more like > procedures than functions. > > Tried it with: > > create table z (a int4, b int4); > ins

sql-select.html ordinal number of an output column.

2022-09-24 Thread jian he
quote from https://www.postgresql.org/docs/current/sql-select.html The elements of the PARTITION BY list are interpreted in much the same > fashion as elements of a GROUP BY > > clause, except that they are always simple express