Re: MS SQL - PostgreSQL

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.

Browse pgsql-general by date

  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