Andrew Gold wrote:
> The following bug has been logged online:
>
> Bug reference: 1486
> Logged by: Andrew Gold
> Email address: agold@cbamedia.com
> PostgreSQL version: 7.4.7
> Operating system: Debian Linux
> Description: Apostrophes are not ignored in pgplsql comments
> Details:
>
> In pgplsql functions, apostrophes in comments are not ignored by the pgplsql
> interpreter. Parsing errors result from correct spelling in comments. For
> example, a comment such as:
>
> -- This can't be a good way to solve this.
>
> will generate errors. This seems to be a general bug and was easily
> duplicated.
I don't think it's a plpgsql problem though - rather an artefact of the
SQL parser. You're actually doing
CREATE FUNCTION foo() RETURNS ... AS <some text value> LANGUAGE ...;
I think the problem is while the SQL parser is processing the text-value
- you need to escape the single-quote to get past that stage of parsing.
There are similar issues with regexp strings.
If you're using dollar-quoting in 8.0 the problem is gone.
--
Richard Huxton
Archonet Ltd