Re: [GENERAL] How to create a stored procedure in PostgreSQL

2011-08-12 Thread Siva Palanisamy
Hi Craig, Thanks a lot for your detailed response. Regards, Siva. -Original Message- From: Craig Ringer [mailto:ring...@ringerc.id.au] Sent: Friday, August 12, 2011 2:14 PM To: Siva Palanisamy Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to create a stored procedure in

Re: [GENERAL] How to create a stored procedure in PostgreSQL

2011-08-12 Thread Craig Ringer
On 12/08/2011 4:22 PM, Siva Palanisamy wrote: Hi All, I have worked in MS SQL Server where we can create a stored procedure that performs some set of queries in tandem. I wish to see a similar feature in PostgreSQL. Please guide me. I searched and found only functions as replacement to stored p

[GENERAL] How to create a stored procedure in PostgreSQL

2011-08-12 Thread Siva Palanisamy
Hi All, I have worked in MS SQL Server where we can create a stored procedure that performs some set of queries in tandem. I wish to see a similar feature in PostgreSQL. Please guide me. I searched and found only functions as replacement to stored procedure in PostgreSQL! Is that so? How functi