Re: Moving from MS SQL Server to PostgreSql 8.3

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(at)yahoo(dot)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(at)postgresql(dot)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/