can you tell me how to use rollback work in 'pgsql' function? and give me a exsample? - Mailing list pgsql-general

From Nee.mem(倪明)
Subject can you tell me how to use rollback work in 'pgsql' function? and give me a exsample?
Date
Msg-id ATLAS-MAILOc7wo95EF000001bc@atlas-mail.atlas-mail.com
Whole thread Raw
Responses Re: can you tell me how to use rollback work in 'pgsql' function? and give me a exsample?
List pgsql-general
i see you wrote on this page 
http://archives.postgresql.org/pgsql-general/2005-07/msg00319.php
  
test exsample:
    create or replace function test()
    returns void as 
    '
    begin 
        delete from regiondata;
        rollback;
    end;
    'language 'plpgsql';
but exception a error:    CONTEXT:  PL/pgSQL function "test" line 3 at SQL statement 
Use others' words :
>It is important not to confuse the use of BEGIN/END for grouping statements
> in PL/pgSQL with the database commands for transaction control. PL/pgSQL's
> BEGIN/END are only for grouping; they do not start or end a transaction
and can you tell me how to use rollback work in 'pgsql' function?  and give me a exsample?

        
 

        alan.nee
        neemem@gmail.com
          2005-07-13

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Transaction Handling in pl/pgsql?
Next
From: Frank Rittinger
Date:
Subject: Re: Windows version of PostgreSQL 8?