[SQL] Converting T-SQL to PostgreSQL

I am trying to re write the following stored proc as a postgresql function..but am new to postgres and it is kind of getting really confusing trying to learn and let alone understand the syntax: CREATE PROCEDURE [dbo].[GetAppAvailability] @AuditAvailable bit output, @B

Re: [SQL] @@Error equivalent in Postgresql

things so i can be able to manipulate it in the code just like you wd use the @returnValue = @@Error. Thanks Pavel Stehule wrote: > > 2009/10/21 maboyz : >> >> Hi, >> >> I am in the process of migrating our database from MS Server 2000 to >> Postgres. I have a b

[SQL] @@Error equivalent in Postgresql

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: ALTER