Re: BUG #14394: No error raised in IN-clause when commas are missing

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pantelis Theodosiou <ypercube(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, andreas(dot)imboden(at)bl(dot)ch, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14394: No error raised in IN-clause when commas are missing
Date: 2016-10-24 19:09:13
Message-ID: 20161024190913.q2uzca5gt2sb72ni@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David G. Johnston wrote:

> ​​Our docs state we (effectively...) replace comments with a single
> space...is this (or can it cause) an incompatibility?
>
> https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-COMMENTS

No, because that space is outside the string literal.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2016-10-24 19:11:47 Re: BUG #14393: Querry plan creation time is too long
Previous Message David G. Johnston 2016-10-24 17:42:22 Re: BUG #14394: No error raised in IN-clause when commas are missing