Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Geoff Tolley <geoff(dot)tolley(at)yougov(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped
Date: 2009-10-08 14:56:29
Message-ID: 20091008145629.GB5510@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera wrote:

> alvherre=# select 'a'
> alvherre-# 'b';
> ?column?
> ----------
> ab
> (1 fila)

Ah, yes -- saith scan.l:

/*
* SQL requires at least one newline in the whitespace separating
* string literals that are to be concatenated. Silly, but who are we
* to argue? Note that {whitespace_with_newline} should not have * after
* it, whereas {whitespace} should generally have a * after it...
*/

special_whitespace ({space}+|{comment}{newline})
horiz_whitespace ({horiz_space}|{comment})
whitespace_with_newline ({horiz_whitespace}*{newline}{special_whitespace}*)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2009-10-08 15:12:03 Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped
Previous Message Alvaro Herrera 2009-10-08 14:54:51 Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped