Re: Moving from Sybase to Postgres - Stored Procedures - Mailing list pgsql-general

From Jaime Casanova
Subject Re: Moving from Sybase to Postgres - Stored Procedures
Date
Msg-id 20050128205112.28333.qmail@web50004.mail.yahoo.com
Whole thread Raw
In response to Re: Moving from Sybase to Postgres - Stored Procedures  ("Frank D. Engel, Jr." <fde101@fjrhome.net>)
List pgsql-general
 --- "Frank D. Engel, Jr." <fde101@fjrhome.net>
escribió:
> a.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-
>
> declarations.html
> b. (same page)
> c. ?
> d.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
>
> structures.html#PLPGSQL-RECORDS-ITERATING
>
>
> This brings about a new question: Doesn't a PL/PGSQL
> function always
> execute within the context of a transaction?  I'd
> think you can't
> create a transaction within one then, correct?
>
AFAIK.

But in pg8 you can use EXCEPTION blocks that are
implemented on the subtransaction mechanism, IIRC.

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Moving from Sybase to Postgres - Stored Procedures
Next
From: guegue
Date:
Subject: upgrading to postgresql 8