Re: [SQL] @@Error equivalent in Postgresql

2009-10-23 Thread Craig Ringer
Pavel Stehule wrote: So the programming based on returning state codes is very obsolete, and little bit difficult. You can emulate, but any protected block creates inner transaction and this should negative effect on speed - and it are some lines more. I'd like to second and emphasise this.

Re: [SQL] @@Error equivalent in Postgresql

2009-10-22 Thread Thomas Pundt
Hi maboyz schrieb: I am in the process of migrating our database from MS Server 2000 to Postgres. I have a bunch of stored procs which i have to modify the syntax so they work in postgresql. My ? is is there an equivalent for the @@Error function in T-SQL for postgres: The stored proc i am

[SQL] @@Error equivalent in Postgresql

2009-10-21 Thread maboyz
Hi, I am in the process of migrating our database from MS Server 2000 to Postgres. I have a bunch of stored procs which i have to modify the syntax so they work in postgresql. My ? is is there an equivalent for the @@Error function in T-SQL for postgres: The stored proc i am converting is:

Re: [SQL] @@Error equivalent in Postgresql

2009-10-21 Thread Pavel Stehule
2009/10/21 maboyz thabani.m...@distributel.ca: Hi, I am in the process of migrating our database from MS Server 2000 to Postgres. I have a bunch of stored procs which i have to modify the syntax so they work in postgresql. My ? is is there an equivalent for the @@Error function in T-SQL for

Re: [SQL] @@Error equivalent in Postgresql

2009-10-21 Thread maboyz
Thanks for the response Pavel. So does this mean i will have to make the @ReturnValue an OUT parameter too??? am a bit confused here, i guess what i am driving at is, i see where you are going with the altered function you suggeted but its fitting the exception handling into the grand scheme of

Re: [SQL] @@Error equivalent in Postgresql

2009-10-21 Thread Pavel Stehule
2009/10/21 maboyz thabani.m...@distributel.ca: Thanks for the response Pavel. So does this mean i will have to make the @ReturnValue an OUT parameter too??? am a bit confused here, i guess what i am driving at is, i see where you are going with the altered function you suggeted but its