[SQL] how to write procedures

2002-07-04 Thread srikanth
Hi, I am using postgre sql server on linux server but for my database I am using storedprocedures which i need to create , but there are no commands to create procedures it says it does not support is there any way to work with stored procedures in postgre sql server. thanks, srikanth. ---

Re: [SQL] how to write procedures

2002-07-04 Thread Achilleus Mantzios
On Thu, 4 Jul 2002, srikanth wrote: You are looking for functions :) Study them a bit and then you will feel grateful for PostgreSQL! > Hi, I am using postgre sql server on linux server but for my database I am > using storedprocedures which i need to create , but there are no commands to > cre

Re: [SQL] how to write procedures

2002-07-04 Thread Rajesh Kumar Mallah.
Hi , Stored procedures are supported in pgsql for quite a long time consult postgresql docs on website http://www.postgresql.org/idocs/index.php?xplang.html or your local installations. regds malz. On Thursday 04 July 2002 16:15, srikanth wrote: > Hi, I am using postgre sql server on linux

Re: [SQL] how to write procedures

2002-07-04 Thread Achilleus Mantzios
On Thu, 4 Jul 2002, Rajesh Kumar Mallah. wrote: Just to add stored procedures in pgsql are implemented thru functions. Popular languages are pg/plsql and "C". > > Hi , > > Stored procedures are supported in pgsql for > quite a long time > > consult postgresql docs on website > http://www.pos

Re: [SQL] how to write procedures

2002-07-09 Thread Bhuvan A
Hi, it seems you weren't yet installed appropriate procedural language. for example, if you wish to code in plpgsql you must install 'plpgsql'. for details refer the documentation and it has enough information. regards, bhuvaneswaran. On Thu, 4 Jul 2002, srikanth wrote: > Hi, I am using post