| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | bugbug(at)shaw(dot)ca, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Stored Procedures |
| Date: | 2003-04-10 22:49:46 |
| Message-ID: | 200304101549.46253.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Dennis,
> How do I implement ms sql style stored procedures in postgre ? I have ms sql
stored procedures like the following to insert data into a db that is called
from a web form:
Stored procedures are called "Functions" in PostgreSQL. See "Create
Function".
> In pgadmin I cant even find anything called stored procedures. Also...how do
I implement @@identity in postgre ?
PostgreSQL has a much more powerful construct called "Sequences". See "CREATE
SEQUENCE".
Better yet, buy a PostgreSQL intro book. There are several, and they are all
pretty good. You're in for a world of pain if you try to figure out
everything piecemeal from the online docs.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2003-04-10 22:54:09 | Re: Stored Procedures |
| Previous Message | bugbug | 2003-04-10 22:38:58 | Stored Procedures |