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