Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-14 Thread Artur Formella
On 13.05.2024 11:24, Matthias van de Meent wrote: On Mon, 13 May 2024 at 10:42, Artur Formella wrote: Motivation: Commas of this type are allowed in many programming languages, in some it is even recommended to use them at the ends of lists or objects. Single trailing commas are a feature

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Tom Lane
=?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= writes: > Tom Lane writes: >> I'm fairly down on this idea for SQL, because I think it creates >> ambiguity for the ROW() constructor syntax. That is: >> (x,y) is understood to be shorthand for ROW(x,y) >> (x) is not ROW(x), it's just x >>

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= writes: >> Matthias van de Meent writes: >>> Single trailing commas are a feature that's more and more common in >>> languages, yes, but arbitrary excess commas is new to me. Could you >>> provide some examples of popular languages

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Tom Lane
=?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= writes: > Matthias van de Meent writes: >> Single trailing commas are a feature that's more and more common in >> languages, yes, but arbitrary excess commas is new to me. Could you >> provide some examples of popular languages which have that, as I

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Dagfinn Ilmari Mannsåker
Matthias van de Meent writes: > On Mon, 13 May 2024 at 10:42, Artur Formella > wrote: >> Motivation: >> Commas of this type are allowed in many programming languages, in some >> it is even recommended to use them at the ends of lists or objects. > > Single trailing commas are a feature that's

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Étienne BERSAC
Hi, As a developer, I love this feature. But as a developer of an universal TDOP SQL parser[1], this can be a pain. Please request it to the standard. Regards, Étienne [1]: https://gitlab.com/dalibo/transqlate

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Matthias van de Meent
On Mon, 13 May 2024 at 10:42, Artur Formella wrote: > Motivation: > Commas of this type are allowed in many programming languages, in some > it is even recommended to use them at the ends of lists or objects. Single trailing commas are a feature that's more and more common in languages, yes, but

Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Artur Formella
Hello! I have created a patch to allow additional commas between columns, and at the end of the SELECT clause. Motivation: Commas of this type are allowed in many programming languages, in some it is even recommended to use them at the ends of lists or objects. A new generation of