plpgsql commenting broken?

From: "Johnny Jørgensen" <pgsql(at)halfahead(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql commenting broken?
Date: 2001-12-04 15:28:47
Message-ID: 200112041628470534.002ED906@mail.halfahead.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After quite a few hours of poring over my latest plpgsql dabbling, i found the error that caused import to barf, and I was a bit surprised, since the error was caused by a single apostrophe in a comment line

-- check if the row isn't available
[SQL thingie]

of course, i could avoid the problem by rewriting my comments to

-- check if the row is available
[SQL thingie]

but it seems to me, that commenting a line should cause the parser to ignore *everything* until the next newline?

regards,
Johnny Jørgensen

johnny(at)halfahead(dot)dk
+45 6315 7328

Responses

Browse pgsql-general by date

  From Date Subject
Next Message colm 2001-12-04 15:42:39 RedHat6.2 - postgres 7.1.2 lib confusion
Previous Message Tom Lane 2001-12-04 15:21:18 Re: Problem (bug?) with like