Home > mailing lists

sql-select.html ordinal number of an output column. - Mailing list pgsql-docs

From	jian he
Subject	sql-select.html ordinal number of an output column.
Date	September 24, 2022 15:40:36
Msg-id	CACJufxEFHdjmYVH9EwiJ9a1_0viHRNrBtZZ8BgbJS4FCu+Hhzw@mail.gmail.com Whole thread Raw
List	pgsql-docs

Tree view

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 expressions and never the name or number of an output column.

I think "number of an output column" refers to "ordinal number of an output column".

I recommend David Deutsch's <<The Beginning of Infinity>>

Jian

pgsql-docs by date:

From: PG Doc comments form
Date: 24 September 2022, 05:41:27
Subject: How to access a database in the pgadmin UI

From: Laurenz Albe
Date: 24 September 2022, 18:14:42
Subject: Re: Do blocks support transaction control?

sql-select.html ordinal number of an output column. - Mailing list pgsql-docs

Previous

Next