David Fetter <da...@fetter.org> writes:
> On Tue, May 09, 2017 at 12:48:01PM -0400, Tom Lane wrote:
>> I don't think that's a problem: while psql will remove "--" and everything
>> following it until newline, it won't remove the newline. So there's still
>> a token boundary there.
> We may still need to be careful.
> davidfetter@davidfetter=# SELECT 'foo'-- stuff goes here
> 'bar';
> ?column?
> ----------
> foobar
> (1 row)
If you read the SQL spec, you'll find that particular behavior is
required by spec, and would still be required by spec with or
without the comment. Perhaps it's a trap for unwary SQL programmers,
but psql isn't making it worse.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
