Re: Moving from Sybase to Postgres - Stored Procedures

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

a.
http://www.postgresql.org/docs/8.0/interactive/plpgsql-
declarations.html
b. (same page)
c. ?
d.
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
structures.html#PLPGSQL-RECORDS-ITERATING

This brings about a new question: Doesn't a PL/PGSQL function always
execute within the context of a transaction? I'd think you can't
create a transaction within one then, correct?

On Jan 28, 2005, at 3:11 PM, Andre Schnoor wrote:

> 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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr. <fde101(at)fjrhome(dot)net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB+qHI7aqtWrR9cZoRAhf1AJ9CVvNTv0+UHtbUqxONyHIHJ67MlQCcCgfZ
K3nUK2CE7Ag7fSQsaaSqStE=
=UgiS
-----END PGP SIGNATURE-----

___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com