Looks like a bug in the driver. Ask the author about it.
Meanwhie, if Pg also supports /*...*/ style comments try using those.
Tim.
On Sat, Apr 07, 2001 at 12:43:53PM +0200, Klaus Reger wrote:
> Hi, all
>
> When I try to create PL/pgsql-prodedures, that contain by example the
> following peace of code:
>
> ------- snip ---------- snip ---------- snip ---------- snip ----------
> --------------------------------------------
> -- Function: sysdate
> -- Date : 2001-04-07 12:40:23?
> --------------------------------------------
> DROP FUNCTION sysdate ();
> CREATE FUNCTION sysdate () RETURNS abstime AS '
> BEGIN
> -- :1 :2 may not be in comments also
> -- ?1 ?2 is not allowed too
> RETURN date(''now'');
> END;
> ' LANGUAGE 'plpgsql';
> ------- snip ---------- snip ---------- snip ---------- snip ----------
>
> with the DBI-methods do or exec, I get the error
>
> Can't mix placeholder styles (?/:1) at
> /usr/lib/perl5/site_perl/5.6.0/i586-linux/DBD/Pg.pm line 109.
>
> masking the ? or : with backslash seems not to help. But whe I paste this
> code in dbish, everything is ok. What have I done wrong?
>
> regards, Klaus
>
> --
> Visit WWWdb at
> http://wwwdb.org