Re: BUG #13655: Incorrect Syntax Error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David <stormbyte(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13655: Incorrect Syntax Error
Date: 2015-10-01 15:46:47
Message-ID: 17682.1443714407@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David <stormbyte(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-10-01 15:50:21 Re: BUG #13659: Constraint names truncated without error
Previous Message jtc331 2015-10-01 14:40:27 BUG #13659: Constraint names truncated without error