Re: FUNCTIONS - Mailing list pgsql-php
From | Aldo Leyva Alvarado |
---|---|
Subject | Re: FUNCTIONS |
Date | |
Msg-id | 002701c40c71$3c2e46c0$3c0000c0@pegasus Whole thread Raw |
In response to | Re: FUNCTIONS ("scott.marlowe" <scott.marlowe@ihs.com>) |
Responses |
Re: FUNCTIONS
|
List | pgsql-php |
I know that in other DB, if you have many Stored Procedure the perfomance could be reduce Aldo ----- Original Message ----- From: "Søren Bentzen" <soren@svendsvej.dk> To: "Aldo Leyva Alvarado" <aleyva@medifarma.com.pe>; "scott.marlowe" <scott.marlowe@ihs.com> Cc: <brew@theMode.com>; <pgsql-php@postgresql.org> Sent: Wednesday, March 17, 2004 4:54 PM Subject: Re: [PHP] FUNCTIONS > Hi > Should I understand your question like this one: How many stones are there > on the moon? > I am not shure that kind of question can answer with an exact number. I > presume it depends on factors like disk space, memory space and other > factors that can be adjusted. I think that a more relevant question could be > how big in bytes, a stored procedure can be? > And why do you want to know that, if the question can be answered? > > BR > Søren > > ----- Original Message ----- > From: "Aldo Leyva Alvarado" <aleyva@medifarma.com.pe> > To: "scott.marlowe" <scott.marlowe@ihs.com> > Cc: <brew@theMode.com>; <pgsql-php@postgresql.org> > Sent: Wednesday, March 17, 2004 10:21 PM > Subject: Re: [PHP] FUNCTIONS > > > > Yes, I know, But I want to know how many STORED PROCEDURE supports > POSTGRES, > > maybe 100 or 500 or maybe more. > > > > Thanks > > > > ----- Original Message ----- > > From: "scott.marlowe" <scott.marlowe@ihs.com> > > To: "Aldo Leyva Alvarado" <aleyva@medifarma.com.pe> > > Cc: <brew@theMode.com>; <pgsql-php@postgresql.org> > > Sent: Wednesday, March 17, 2004 11:22 AM > > Subject: Re: [PHP] FUNCTIONS > > > > > > > In Postgresql, a stored procedure is created using a user defined > > > function, and accessed with something simple like: > > > > > > select myfunc('arg1','arg2'); > > > > > > So, it's just another select statement to PHP/Postgresql. You don't > have > > > to do anything fancy to hit a stored procedure. > > > > > > On Tue, 16 Mar 2004, Aldo Leyva Alvarado wrote: > > > > > > > Thanks, > > > > but I talked about to STORE PROCEDURE. > > > > > > > > > > > > Aldo Leyva > > > > > > > > ----- Original Message ----- > > > > From: <brew@theMode.com> > > > > To: <aleyva@medifarma.com.pe> > > > > Cc: <pgsql-php@postgresql.org> > > > > Sent: Monday, March 15, 2004 10:33 PM > > > > Subject: Re: [PHP] FUNCTIONS > > > > > > > > > > > > > > > > > > Aldo...... > > > > > > > > > > > Can you tell me how many functions supports POSTGRES? > > > > > > > > > > I'm not going to count them, but you can total them up and read all > > about > > > > > them in Chapter LXXXIV of the php manual, entitled PostgreSQL > > Functions. > > > > > The url is: > > > > > > > > > > http://us4.php.net/manual/en/ref.pgsql.php > > > > > > > > > > Or another of the mirrors. > > > > > > > > > > brew > > > > > > > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > > > TIP 6: Have you searched our list archives? > > > > > > > > > > http://archives.postgresql.org > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to choose an index scan if your > > joining column's datatypes do not match > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)