From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: jindrich@vavruska.cz
Subject: Section 4.1.2.7 contains false information
Date: Tue, 09 Apr 2019 15:08:15 +0000
Message-ID: <155482249597.1372.1459692771442036097@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-syntax-lexical.html
Description:
QUOTE:
The CAST() syntax conforms to SQL. The type 'string' syntax is a
generalization of the standard: SQL specifies this syntax only for a few
data types, but PostgreSQL allows it for all types. The syntax with :: is
historical PostgreSQL usage, as is the function-call syntax.
UNQUOTE
In fact, this is not 100% true. TIMESTAMP 'string' does not work this way.
It is mentioned in section 4.2.9 that TIMESTAMP( 'string') cannot be used,
but it does not mention TIMESTAMP 'string'.
I would really prefer if the respective information could be clear,
unequivocal, complete and included in other sections of the manual where it
is due, i.e. in sections 8.5 and 9.9 which deal with date & time types and
operators.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, jindrich@vavruska.cz
Subject: Re: Section 4.1.2.7 contains false information
In-Reply-To: <155482249597.1372.1459692771442036097@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox