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

Reply via email to