From: | "Zolof" <zolof(at)club-internet(dot)fr> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org(dot)pgsql-interfaces(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org |
Subject: | pl/pgSQL & transaction |
Date: | 2001-01-18 17:17:27 |
Message-ID: | 9478lh$1m2r$2@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general pgsql-interfaces pgsql-sql |
This code doesn't work. I use Begin Work to start a transaction but BEGIN is
a PL/pgSQL command so I have a parse error when executing it.
CREATE FUNCTION a () RETURNS int4 AS '
BEGIN
BEGIN WORK;
COMMIT WORK;
return 1;
END;
' LANGUAGE 'plpgsql';
What's wrong ????
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-01-18 23:48:54 | Re: docs: syntax.sgml patch |
Previous Message | Zolof | 2001-01-18 17:16:32 | Pl/pgSQL & TRANSACTION |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-01-18 17:27:12 | Re: Tuning queries and distinct behaviour |
Previous Message | Gordan Bobic | 2001-01-18 17:16:33 | Another optimizer question |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 2001-01-18 17:44:08 | JDBC: New updates to CVS |
Previous Message | Craig Brozefsky | 2001-01-18 16:01:37 | Re: issues with libpg interface |
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Haberlach | 2001-01-18 17:37:13 | Re: Help with query. (*) |
Previous Message | guard | 2001-01-18 15:00:40 | Distributed database ? |