Re: SQL comments - Mailing list pgsql-novice

From Jaime Casanova
Subject Re: SQL comments
Date
Msg-id c2d9e70e0606111438q64a5e439jef30a9b5b71b0cea@mail.gmail.com
Whole thread Raw
In response to Re: SQL comments  (Tom Allison <tallison@tacocat.net>)
Responses Re: SQL comments  ("Jaime Casanova" <systemguards@gmail.com>)
Re: SQL comments  (Tom Allison <tallison@tacocat.net>)
List pgsql-novice
> Found them, eventually.
> I was trying to insert a comment in the middle of a line:
>
> select status, reason, --method
> from....
>

Actually, you can put a comment in the middle of a line. Your mistake
in the above statement is because of the comma before the command, the
parser sees this:

select status, reason, from ....

it's completely legal to write:
select status, reason --method
from mytable         -- line 2

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

pgsql-novice by date:

Previous
From: Tom Allison
Date:
Subject: uh-oh
Next
From: "Jaime Casanova"
Date:
Subject: Re: SQL comments