Transition from MS-SQL - Store Procedures? - Mailing list pgsql-general

From services-google@markpennell.com (Mark E. Pennell)
Subject Transition from MS-SQL - Store Procedures?
Date
Msg-id 57ad29fe.0109141306.aed20aa@posting.google.com
Whole thread Raw
List pgsql-general
I am transitioning from MS-SQL to Postgresql.  In
evaluting how to bring over MS-SQL Stored Procedures,
I have looked at the CREATE FUNCTION capability of pg.

I have a few questions

(A) does pg support IF/THEN/ELSE logic in the
created functions?  I have not seen it anywhere.

(B) does pg support anything like @@ERROR?  For instance,
I want the next sql line in the function to be
different depending of the result of the last.

Any tips are appreciated.

pgsql-general by date:

Previous
From: peace_flower
Date:
Subject: NewYork Bombing: SQL server bomb proof!!
Next
From: "kingking"
Date:
Subject: Longtime to store large object from Visual Foxpro throught ODBC