Re: [SQL] commit inside plpgsql function

2004-12-24 Thread Gregory S. Williamson
llowed. The 8.0 documentation on user defined procedures would probably say. Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Dennis Sacks [mailto:[EMAIL PROTECTED] Sent: Tue 12/21/2004 9:21 AM To: pgsql-sql@postgresql.org Cc: Subject: [SQL] commit inside p

[SQL] commit inside plpgsql function

2004-12-24 Thread Dennis Sacks
Hi, I am converting oracle stored procedures to plpgsql. There are several of the oracle procedures where a parameter vCommit is passed into the procedure and: if vCommit = 1 then commit; do_something_commit(vdate); else do_something(vdate); end if; does this make s