pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
FUNCTIONS
9+ messages / 6 participants
[nested] [flat]

* FUNCTIONS
@ 2004-03-16 02:14  aleyva@medifarma.com.pe
  0 siblings, 1 reply; 9+ messages in thread

From: aleyva@medifarma.com.pe @ 2004-03-16 02:14 UTC (permalink / raw)
  To: pgsql-php-postgresql.org@localhost.postgresql.org; +Cc: pgsql-php

Hello
I have a question,
Can you tell me how many functions supports POSTGRES?

Thanks
Aldo Leyva

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-16 03:33  brew@theMode.com
  parent: aleyva@medifarma.com.pe
  0 siblings, 1 reply; 9+ messages in thread

From: brew@theMode.com @ 2004-03-16 03:33 UTC (permalink / raw)
  To: aleyva@medifarma.com.pe; +Cc: pgsql-php


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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-16 21:45  Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  parent: brew@theMode.com
  0 siblings, 1 reply; 9+ messages in thread

From: Aldo Leyva Alvarado @ 2004-03-16 21:45 UTC (permalink / raw)
  To: brew@theMode.com; +Cc: pgsql-php

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-17 16:22  scott.marlowe <scott.marlowe@ihs.com>
  parent: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  0 siblings, 1 reply; 9+ messages in thread

From: scott.marlowe @ 2004-03-17 16:22 UTC (permalink / raw)
  To: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>; +Cc: brew@theMode.com; pgsql-php

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
> 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-17 21:21  Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  parent: scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 2 replies; 9+ messages in thread

From: Aldo Leyva Alvarado @ 2004-03-17 21:21 UTC (permalink / raw)
  To: scott.marlowe <scott.marlowe@ihs.com>; +Cc: brew@theMode.com; pgsql-php

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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-17 21:47  Rod Taylor <pg@rbt.ca>
  parent: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  1 sibling, 0 replies; 9+ messages in thread

From: Rod Taylor @ 2004-03-17 21:47 UTC (permalink / raw)
  To: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>; +Cc: Scott Marlowe <scott.marlowe@ihs.com>; brew@theMode.com; pgsql-php

On Wed, 2004-03-17 at 16:21, Aldo Leyva Alvarado wrote:
> Yes, I know, But I want to know how many STORED PROCEDURE supports POSTGRES,
> maybe 100 or 500  or maybe more.

I suppose the limit would be the number of OIDs you can fit into
pg_proc.

This is a little over 4 billion.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-17 21:54  Søren Bentzen <soren@svendsvej.dk>
  parent: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  1 sibling, 1 reply; 9+ messages in thread

From: Søren Bentzen @ 2004-03-17 21:54 UTC (permalink / raw)
  To: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>; scott.marlowe <scott.marlowe@ihs.com>; +Cc: brew@theMode.com; pgsql-php

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
>




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-17 22:43  Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  parent: Søren Bentzen <soren@svendsvej.dk>
  0 siblings, 1 reply; 9+ messages in thread

From: Aldo Leyva Alvarado @ 2004-03-17 22:43 UTC (permalink / raw)
  To: Søren Bentzen <soren@svendsvej.dk>; scott.marlowe <scott.marlowe@ihs.com>; +Cc: brew@theMode.com; 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)




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: FUNCTIONS
@ 2004-03-19 15:48  scott.marlowe <scott.marlowe@ihs.com>
  parent: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
  0 siblings, 0 replies; 9+ messages in thread

From: scott.marlowe @ 2004-03-19 15:48 UTC (permalink / raw)
  To: Aldo Leyva Alvarado <aleyva@medifarma.com.pe>; +Cc: Søren Bentzen <soren@svendsvej.dk>; brew@theMode.com; pgsql-php

In Postgresql, the number of stored procedures isn't really an issue.  
however, the efficiency of those stored procedures, and the table schema 
they operate on is quite important.

Make sure your fk/pk relationships are of the same data type.
Make sure you aren't writing triggers that wind up being accidentally 
recursive
Stored procedures in C are usually the fastest, but plpgsql and plsql are 
both quite acceptable performers.

I would worry more about database tuning and proper design of the schema 
than the stored procs.  Make as many UDFs (user defined functions, the 
postgresql name for a stored procedure, sorta) as you want, the number of 
them won't be an issue.

On Wed, 17 Mar 2004, Aldo Leyva Alvarado wrote:

> 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)
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2004-03-19 15:48 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-16 02:14 FUNCTIONS aleyva@medifarma.com.pe
2004-03-16 03:33 ` brew@theMode.com
2004-03-16 21:45   ` Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
2004-03-17 16:22     ` scott.marlowe <scott.marlowe@ihs.com>
2004-03-17 21:21       ` Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
2004-03-17 21:47         ` Rod Taylor <pg@rbt.ca>
2004-03-17 21:54         ` Søren Bentzen <soren@svendsvej.dk>
2004-03-17 22:43           ` Aldo Leyva Alvarado <aleyva@medifarma.com.pe>
2004-03-19 15:48             ` scott.marlowe <scott.marlowe@ihs.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