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/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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
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
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
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
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.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Hi
Should I understand your question like this one: How many stones are ther=
e
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=F8ren
----- 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 a=
ll
> 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 y=
our
> 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)
I know that in other DB, if you have many Stored Procedure the perfomance
could be reduce
Aldo
----- Original Message -----
From: "S=F8ren Bentzen"
To: "Aldo Leyva Alvarado"
Cc:
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 th=
ere
> 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 cou=
ld
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=F8ren
>
> ----- 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
> >
>
>
> ---------------------------(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
In Postgresql, the number of stored procedures isn't really an issue. =20
however, the efficiency of those stored procedures, and the table schema=20
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=20
recursive
Stored procedures in C are usually the fastest, but plpgsql and plsql are=
=20
both quite acceptable performers.
I would worry more about database tuning and proper design of the schema=20
than the stored procs. Make as many UDFs (user defined functions, the=20
postgresql name for a stored procedure, sorta) as you want, the number of=
=20
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 perfoman=
ce
> could be reduce
>=20
> Aldo
> ----- Original Message -----
> From: "S=F8ren Bentzen"
> To: "Aldo Leyva Alvarado"
>
> Cc:
> Sent: Wednesday, March 17, 2004 4:54 PM
> Subject: Re: [PHP] FUNCTIONS
>=20
>=20
> > 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 c=
ould
> 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=F8ren
> >
> > ----- 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 do=
n'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 re=
ad
> 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.o=
rg)
>=20
>=20
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 6: Have you searched our list archives?
>=20
> http://archives.postgresql.org
>=20
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org