Reserved keywords and qualified identifiers

From: cowwoc <cowwoc(at)bbs(dot)darktech(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Reserved keywords and qualified identifiers
Date: 2014-09-19 06:17:15
Message-ID: 1411107435868-5819597.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

http://dev.mysql.com/doc/refman/5.7/en/reserved-words.html explicitly states
that qualified identifiers do not have to be quoted even if they are
reserved keywords ("A word that follows a period in a qualified name must be
an identifier, so it need not be quoted even if it is reserved").

http://www.postgresql.org/docs/9.3/static/sql-keywords-appendix.html does
not seem to discuss this topic but empirical evidence seems to indicate
PostgreSQL shares the same behavior.

Is it possible to document the expected behavior? I need to know this
information to fix this related bug:
https://github.com/querydsl/querydsl/issues/936

Thanks,
Gili

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Reserved-keywords-and-qualified-identifiers-tp5819597.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philipp Kraus 2014-09-19 06:35:33 cloning database
Previous Message Peter Geoghegan 2014-09-19 04:38:20 Re: 64-bit TXID?