Re: MS SQL - PostgreSQL - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: MS SQL - PostgreSQL
Date
Msg-id 1126678669.28391.44.camel@Andrea.peacock.de
Whole thread Raw
In response to MS SQL - PostgreSQL  ("Irfan Syukur" <irfan_syukur@bri.co.id>)
List 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.


pgsql-general by date:

Previous
From: Gnanavel S
Date:
Subject: Re: Partial dates
Next
From: "Ilja Golshtein"
Date:
Subject: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again