From: | dvanatta <dvanatta(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Moving from MS SQL Server to PostgreSql 8.3 |
Date: | 2009-10-01 16:15:24 |
Message-ID: | 25699423.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-10-01 16:25:08 | Re: Connect to database with php pg_connect, cannot find table even though it shows up on psql connection |
Previous Message | Mary Anderson | 2009-10-01 15:40:47 | Connect to database with php pg_connect, cannot find table even though it shows up on psql connection |