pl/pgSQL & transaction - Mailing list pgsql-general

From Zolof
Subject pl/pgSQL & transaction
Date
Msg-id 9478lh$1m2r$2@news.tht.net
Whole thread Raw
Responses Re: [INTERFACES] pl/pgSQL & transaction
List pgsql-general
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 ????




pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: How do I import table information?
Next
From: "Adam Lang"
Date:
Subject: Re: MS Access data to PostgrSQL data