pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to write procedures
5+ messages / 4 participants
[nested] [flat]
* how to write procedures
@ 2002-07-04 10:45 srikanth <chekravarthula@haloesolutions.com>
0 siblings, 3 replies; 5+ messages in thread
From: srikanth @ 2002-07-04 10:45 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to write procedures
@ 2002-07-04 13:17 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: srikanth <chekravarthula@haloesolutions.com>
2 siblings, 0 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-07-04 13:17 UTC (permalink / raw)
To: srikanth <chekravarthula@haloesolutions.com>; +Cc: pgsql-sql
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
> create procedures it says it does not support is there any way to work with
> stored procedures in postgre sql server.
> thanks,
> srikanth.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to write procedures
@ 2002-07-04 14:12 Rajesh Kumar Mallah. <mallah@trade-india.com>
parent: srikanth <chekravarthula@haloesolutions.com>
2 siblings, 1 reply; 5+ messages in thread
From: Rajesh Kumar Mallah. @ 2002-07-04 14:12 UTC (permalink / raw)
To: srikanth <chekravarthula@haloesolutions.com>; pgsql-sql
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 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.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to write procedures
@ 2002-07-04 15:56 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Rajesh Kumar Mallah. <mallah@trade-india.com>
0 siblings, 0 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-07-04 15:56 UTC (permalink / raw)
To: Rajesh Kumar Mallah. <mallah@trade-india.com>; +Cc: srikanth <chekravarthula@haloesolutions.com>; pgsql-sql
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.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 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.
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to write procedures
@ 2002-07-09 04:40 Bhuvan A <bhuvansql@linuxfreemail.com>
parent: srikanth <chekravarthula@haloesolutions.com>
2 siblings, 0 replies; 5+ messages in thread
From: Bhuvan A @ 2002-07-09 04:40 UTC (permalink / raw)
To: pgsql-sql
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 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.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-07-09 04:40 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-04 10:45 how to write procedures srikanth <chekravarthula@haloesolutions.com>
2002-07-04 13:17 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-07-04 14:12 ` Rajesh Kumar Mallah. <mallah@trade-india.com>
2002-07-04 15:56 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-07-09 04:40 ` Bhuvan A <bhuvansql@linuxfreemail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox