X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1E484D1E90F for ; Wed, 17 Mar 2004 21:55:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96125-03 for ; Wed, 17 Mar 2004 17:55:53 -0400 (AST) Received: from linux-gw.svendsvej.dk (unknown [193.88.67.26]) by svr1.postgresql.org (Postfix) with ESMTP id E0DC7D1E8C6 for ; Wed, 17 Mar 2004 17:55:49 -0400 (AST) Received: from [10.1.1.10] (helo=OL51651) by linux-gw.svendsvej.dk with smtp (Exim 3.22 #1 (Red Hat Linux)) id 1B3izS-0006lz-00; Wed, 17 Mar 2004 22:54:18 +0100 Message-ID: <001201c40c6a$65a89430$0a01010a@corp.novocorp.net> From: =?iso-8859-1?Q?S=F8ren_Bentzen?= To: "Aldo Leyva Alvarado" , "scott.marlowe" Cc: , References: <002701c40c65$cf1dbf80$3c0000c0@pegasus> Subject: Re: FUNCTIONS Date: Wed, 17 Mar 2004 22:54:17 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/42 X-Sequence-Number: 2641 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" To: "scott.marlowe" Cc: ; 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" > To: "Aldo Leyva Alvarado" > Cc: ; > 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: > > > To: > > > Cc: > > > 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 >