Re: Stored Procedures

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