Moving from Sybase to Postgres - Stored Procedures

From: "Andre Schnoor" <andre(dot)schnoor(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving from Sybase to Postgres - Stored Procedures
Date: 2005-01-28 20:11:02
Message-ID: 35vkh1F4r71raU1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses

a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.

I can't seem to find these things in the Postgres function syntax.
Procedures can be as long as 20-250 lines, performing heavy data
manipulation tasks, running from a few seconds up to several hours. Database
size is approx. 20GB.

Functions in pgsql are very limited compared to Sybase procedures, so I'll
have to find a workaround somehow. Perhaps somebody can point me to examples
or hints regarding this issue.

Thanks in advance!

Andre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Wilson 2005-01-28 20:28:32 Pg database, need a solution to a problem
Previous Message Dann Corbit 2005-01-28 20:00:37 Re: Splitting queries across servers