Re: [SQL] MS-SQL Store Procedure to Postgresql Function

2012-02-02 Thread Pavel Stehule
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 -

Re: [SQL] MS-SQL Store Procedure to Postgresql Function

2012-02-02 Thread 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. A + Le 30/01/2012 07:42, Rehan Saleem a écrit : hi , how i can convert this store procedure to PostgreSQL function, e

Re: [SQL] MS-SQL Store Procedure to Postgresql Function

2012-02-02 Thread Jasen Betts
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