Обсуждение: Moving from MS SQL Server to PostgreSql 8.3
I am converting my Sql Server stored procs to Postrgre functions. I have the following stored proc: create stored procedures (@lastname varchar(50)) as select firstname ,lastname from users where lastname = @lastname Looking at the documentation for Postgres functions has me confused. I don't want to create a Table Type for each of my stored procs. I am wanting the function to have minimal syntax as possible, like the Sql Server stored proc. I read somewhere -- can't find it now -- that Postgres 8.3 had some "syntactical sugar" to make functions act more like Sql Server stored procs with less syntax. Can someone please show me what this simple stored proc would look like in Postgres 8.3 with minimal syntax? Thanks -- View this message in context: http://www.nabble.com/Moving-from-MS-SQL-Server-to-PostgreSql-8.3-tp25699423p25699423.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
Read these links: http://www.postgresql.org/docs/8.3/interactive/plpgsql-structure.html http://www.postgresql.org/docs/8.3/interactive/plpgsql.html http://www.postgresql.org/docs/8.3/interactive/datatype.html http://www.postgresql.org/docs/8.3/interactive/functions.html 2009/10/1 dvanatta <dvanatta@yahoo.com>: > > I am converting my Sql Server stored procs to Postrgre functions. I have the > following stored proc: > > create stored procedures (@lastname varchar(50)) > as > select > firstname > ,lastname > from users > where lastname = @lastname > > Looking at the documentation for Postgres functions has me confused. I > don't want to create a Table Type for each of my stored procs. I am wanting > the function to have minimal syntax as possible, like the Sql Server stored > proc. I read somewhere -- can't find it now -- that Postgres 8.3 had some > "syntactical sugar" to make functions act more like Sql Server stored procs > with less syntax. > > Can someone please show me what this simple stored proc would look like in > Postgres 8.3 with minimal syntax? > > Thanks > -- > View this message in context: http://www.nabble.com/Moving-from-MS-SQL-Server-to-PostgreSql-8.3-tp25699423p25699423.html > Sent from the PostgreSQL - novice mailing list archive at Nabble.com. > > > -- > Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-novice > -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/