Re: END is not a reserved word

Thanks,

Just found the note on

https://www.postgresql.org/docs/release/14.0/

Reduce the number of keywords that can't be used as column labels without AS (Mark Dilger) §<https://postgr.es/c/06a7c3154>
*
There are now 90% fewer restricted keywords.
Next time I will read the releases changes before I post.

Thanks again

Vicky

________________________________
De: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Enviado: lunes, 25 de agosto de 2025 06:53 p. m.
Para: Vicky Vergara <vicky_vergara(at)hotmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Asunto: Re: END is not a reserved word

On Mon, Aug 25, 2025 at 3:49 PM Vicky Vergara <vicky_vergara(at)hotmail(dot)com<mailto:vicky_vergara(at)hotmail(dot)com>> wrote:
On the list of reserved words, END is marked as reserved.
https://www.postgresql.org/docs/current/sql-keywords-appendix.html

The text on that page notes a couple of times that using reserved words as column labels is accepted - with the only caveat being sometimes you have to use 'AS'.

There may be some that do not get accepted for some reason or other but it's always OK if they are accepted as column labels.

David J.