From: | Brian Modra <brian(at)zwartberg(dot)com> |
---|---|
To: | dvanatta <dvanatta(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Moving from MS SQL Server to PostgreSql 8.3 |
Date: | 2009-10-04 04:33:58 |
Message-ID: | 5a9699850910032133vcd45488x89e907e0ff8b8628@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Bednarz | 2009-10-04 19:23:30 | Installation on Windows 2003 fails |
Previous Message | paresh masani | 2009-10-02 11:44:33 | usage of spi_prepare from PL/Perl |