Thread: Reserved keywords and qualified identifiers

Reserved keywords and qualified identifiers

From
cowwoc
Date:
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.


Re: Reserved keywords and qualified identifiers

From
David G Johnston
Date:
cowwoc wrote
> 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

It isn't a conscious decision - the logic noted in MySQL applies here as
well: the parser is never faced with an ambigious situation which would
cause a syntax error so the use of quotes to dis-ambiguity is not required.
Though the other effects of (reasons for) quoting identifiers in PostgreSQL
still apply.

Given your empirical evidence and the above logic it's safe to say that the
behavior you see is expected.

David J.




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