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