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/
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных