--- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.com> wrote:
> in the pgadmin edit
> i want use
> declare ...
> if exists ...
> insert something if @@rowcout>0 then do something
> if ....
> like in mssql and not use function
I take it that you are looking to create stored procedures? In postgresql they are called "stored functions" or more
correctly"functions."
First you will need to load a procedural language into your database if one isn't already installed.
http://www.postgresql.org/docs/8.2/interactive/sql-createlanguage.html
You should probably use PLpgSQL since it is available across OS all platforms and is easy to learn and use.
http://www.postgresql.org/docs/8.2/interactive/plpgsql.html
There are some nice examples in this documentation.
Your PGadmin will also have features to help the create these functions also.
Regards,
Richard Broersma Jr.
