Search Postgresql Archives

Re: Moving from Sybase to Postgres - Stored Procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 --- "Frank D. Engel, Jr." <fde101@xxxxxxxxxxx>
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux