Update documentation for SET to include SCHEMA / NAMES syntax
Hi,
The attached patch updates the documentation for the SET statement to
include the special syntax for SCHEMA / NAMES in the synopsis. The
current documentation only mentions this special syntax under the
parameters, which is confusing and different from the usual practice.
We could consider also moving the description on the special syntax up
to the description instead of keeping it under parameters, but the
TIME ZONE variant is already explained under the parameters too so I
thought better to keep the current structure.
Thanks,
Álvaro Rodríguez
Attachments:
v1-0001-Update-the-SET-statement-documentation-for-clarit.patchapplication/octet-stream; name=v1-0001-Update-the-SET-statement-documentation-for-clarit.patchDownload+1-1
=?UTF-8?B?w4FsdmFybyBSb2Ryw61ndWV6?= <alvarorodriguez.garcia@datadoghq.com> writes:
The attached patch updates the documentation for the SET statement to
include the special syntax for SCHEMA / NAMES in the synopsis. The
current documentation only mentions this special syntax under the
parameters, which is confusing and different from the usual practice.
Hmm. It's true that SET SCHEMA / SET NAMES are in the SQL standard,
but I think they are semi-deprecated for Postgres despite that.
They are confusing because they are aliases for GUC parameters that
are named significantly differently from the standard's syntax,
so I doubt we want to encourage their use. That being the case,
I'm content to leave them buried in the Parameters section.
SET TIME ZONE is also a SQL-standard thing, but it's more acceptable
because the syntax is sufficiently closely related to the GUC's name.
regards, tom lane