Re: BUG #13655: Incorrect Syntax Error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13655: Incorrect Syntax Error
Date
Msg-id 17682.1443714407@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #13655: Incorrect Syntax Error  (David <stormbyte@gmail.com>)
List pgsql-bugs
David <stormbyte@gmail.com> writes:
> Isn't it inconsistent that a thing like: "someField"SMALLINT works
> whether a thing like: "someField""SomeCustomType" is not working?

Well, you can debate how consistent it is, but that behavior is required
by SQL standard.  Per spec, "foo""bar" is a single identifier containing
an embedded double quote (just one).  It's not two adjacent tokens,
whereas "foo"keyword does represent two tokens.

            regards, tom lane

pgsql-bugs by date:

Previous
From: jtc331@gmail.com
Date:
Subject: BUG #13659: Constraint names truncated without error
Next
From: Tom Lane
Date:
Subject: Re: BUG #13659: Constraint names truncated without error