Re: [PHP] Re: Stored Procedures

2002-07-09 Thread Richard Lynch
>On Sat, 06 Jul 2002 15:27:47 -0500 >> Do you have *ANY* idea how quickly: >> >> "select * from MyTable" can be parsed and an execution plan selected?! >> >> It's CHUMP CHANGE in time. >> >> *ONLY* if your SQL is so incredibly complicated that you can't even >> understand it will the parse/comp

Re: [PHP] Re: Stored Procedures

2002-07-06 Thread James Drabb
On Sat, 06 Jul 2002 15:27:47 -0500 "Richard Lynch" <[EMAIL PROTECTED]> wrote: > Do you have *ANY* idea how quickly: > > "select * from MyTable" can be parsed and an execution plan selected?! > > It's CHUMP CHANGE in time. > > *ONLY* if your SQL is so incredibly complicated that you can't even

Re: [PHP] Re: Stored Procedures

2002-07-06 Thread Richard Lynch
>Stored procedures are like any other type of programming construct. >You can do them right or you can do them wrong. Yeah, and GOTO is perfectly fine... In the right place. >When making a stored >procedure you should stick to ansi SQL as much as possible. All my SQL was so dirt-simple, it coul

Re: [PHP] Re: Stored Procedures

2002-07-06 Thread James Drabb
On Sat, 06 Jul 2002 01:16:28 -0500 "Richard Lynch" <[EMAIL PROTECTED]> wrote: > > I'm using a postgres datbase for my PHP project, how do I make stored > >procedures? Or if no SPs then what would be recomendation for building > >simple/reuseable "Put" and "Get" procedures for my data? > > Wel

[PHP] Re: Stored Procedures

2002-07-05 Thread Richard Lynch
> I'm using a postgres datbase for my PHP project, how do I make stored >procedures? Or if no SPs then what would be recomendation for building >simple/reuseable "Put" and "Get" procedures for my data? Well, if nothing else, PostgreSQL does support user-defined functions, going 'way back. Tec

Re: [PHP] Re: Stored Procedures

2002-07-05 Thread Mark McCulligh
; > - Original Message - > From: "Mark McCulligh" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, July 05, 2002 1:45 PM > Subject: [PHP] Re: Stored Procedures > > > > I think postgres doesn't support store procedure / triggers.

RE: [PHP] Re: Stored Procedures

2002-07-05 Thread Lazor, Ed
MySQL does in 4.0, but that's in alpha right now. -Original Message- Postgres supports stored procedures, triggers and views to name a few where mysql does not... This message is intended for the sole use of th

Re: [PHP] Re: Stored Procedures

2002-07-05 Thread B i g D o g
Actually, Postgres supports stored procedures, triggers and views to name a few where mysql does not... B i g D o g - Original Message - From: "Mark McCulligh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 05, 2002 1:45 PM Subject: [PHP] Re: S

[PHP] Re: Stored Procedures

2002-07-05 Thread Mark McCulligh
I think postgres doesn't support store procedure / triggers. Just like MySQL doesn't. Mark. -- _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] "David Busby" <[EMAIL PROTECTED]> wrote in mes