Re: Update documentation for SET to include SCHEMA / NAMES syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Update documentation for SET to include SCHEMA / NAMES syntax
Дата
Msg-id 1339792.1774633991@sss.pgh.pa.us
обсуждение
Ответ на Update documentation for SET to include SCHEMA / NAMES syntax  (Álvaro Rodríguez <alvarorodriguez.garcia@datadoghq.com>)
Список pgsql-hackers
=?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



В списке pgsql-hackers по дате отправления: