| 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: | Whole Thread | Raw Message | 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 ? |