On 2012-01-30, Rehan Saleem wrote:
>hi , how i can convert this store procedure to PostgreSQL function,
>especially I really dont know how to set type to readonly in PostgreSQL.
>thanksUserACUserAC
I don't actually understand T-SQL so I'm going from the
structure more than from the actual meanin
Actullay there is no transaction support in internal PG routines.
So the code you posted is not translatable in PG PL/SQL because it
involve a transaction inside the process.
A +
Le 30/01/2012 07:42, Rehan Saleem a écrit :
hi , how i can convert this store procedure to PostgreSQL function,
e
Hello
2012/2/2 F. BROUARD / SQLpro :
> Actullay there is no transaction support in internal PG routines.
> So the code you posted is not translatable in PG PL/SQL because it involve a
> transaction inside the process.
It is not exact in this case - it is error handling - and plpgsql
supports it -