Re: insert statements

On Thu, 14 Mar 2002, Vince Vielhaber wrote:

> On Thu, 14 Mar 2002, Rod Taylor wrote:
>
> > As snipped from:
> > http://archives.postgresql.org/pgsql-bugs/2000-10/msg00030.php (All
> > my stuff is in paper form)
> > What's your definition of "other dbs"? The above statement is quite
> > clearly in violation of the SQL92 and SQL99 specifications:
>
> And nowhere does it say that <column name> cannot be qualified with
> the table name in front of it. Looking at the entire message noted

AFAICS periods are not valid in identifiers that are not double
quoted (section 5.2 has the rules on regular identifiers and delimited
ones)

<regular identifier> ::= <identifier body>

<identifier body> ::=
<identifier start> [ { <underscore> | <identifier part> }... ]

<identifier start> ::= !! See the Syntax Rules

<identifier part> ::=
<identifier start>
| <digit>
identifier start is a simple latin letter, a letter in the character
repertoire that's in use, a syllable in the repertoire or an ideograph in
the repertoire.

identifier is defined as either a regular identifier or a delimited one
(ie double quoted). So column name cannot contain periods.

That being said, is this something that's worth adding due to general
usage by other systems?