Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

Andre Schnoor wrote: "Joshua D. Drake" wrote: 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 f

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

<[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > > CREATE PROCEDURE do_something > > @song_id int, > > @user_id int, > > @method int, > > @length int = 0, > > @date_exact datetime, > > @default_country int = null > > AS > >-- temporary variables > >

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

Have you tried looking at this section of the manual? http://www.postgresql.org/docs/7.4/interactive/plpgsql.html It details all the PL/pgSQL language constructs - I found it fine when converting from Oracle to Postgres... Just make sure you have installed the pl/pgsql language in template1 or y

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

> CREATE PROCEDURE do_something > @song_id int, > @user_id int, > @method int, > @length int = 0, > @date_exact datetime, > @default_country int = null > AS >-- temporary variables >DECLARE > @artist int, > @sample int, > @date varchar(32), >

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

"Joshua D. Drake" wrote: > 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.

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

--- "Frank D. Engel, Jr." <[EMAIL PROTECTED]> escribió: > 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 > > > T

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

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 synta

Re: [GENERAL] 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'

[GENERAL] Moving from Sybase to Postgres - Stored Procedures

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