From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Irfan Syukur <irfan_syukur(at)bri(dot)co(dot)id> |
Subject: | Re: MS SQL - PostgreSQL |
Date: | 2005-09-14 06:17:49 |
Message-ID: | 1126678669.28391.44.camel@Andrea.peacock.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am Mittwoch, den 14.09.2005, 13:02 +0700 schrieb Irfan Syukur:
> Dear Tino,
>
> Thanks for your answer.
>
> Can PostGreSQL handle dynamic 'stored procedure'
whatever that means? :)
Postgres stored functions are not fully equivalent to
MSSQL stored procedures. Instead you use them just like
regular database functions or even tables.
> Can you give an example of writing 'stored procedure' in PostgreSQL ??
Did you have a look into the documentation?
http://www.postgresql.org/docs/8.0/static/
and specifically:
http://www.postgresql.org/docs/8.0/static/xplang.html
try it - the postgres documentation is really good!
btw, this would be worth reading (not only for you ;))
http://www.netmeister.org/news/learn2quote.html
HTH
Tino Wildenhain
PS: your mail server has a problem by now. I got an
error.
From | Date | Subject | |
---|---|---|---|
Next Message | Ilja Golshtein | 2005-09-14 07:14:56 | CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again |
Previous Message | Gnanavel S | 2005-09-14 05:15:07 | Re: Partial dates |