Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL

2003-12-01 Thread Jay O'Connor
> >If you need more power IMO Python is the way to go. > I am not that familiar with pything, not to get off topic here but what you >can do in python that you can't do in PHP? Well if they are both Turing complete, arguably not much :) It's not the 'what' it's the 'how' I'm equating Perl with

Re: [GENERAL] Good open source mailing list system PHP / Postgresql

2003-12-01 Thread Jay O'Connor
At 04:03 PM 12/01/2003 -0500, you wrote: > and I believe the the OOP features available in PHP 5, will easily leapfrog over Perl. As my daddy used to say "twice zero is still a small number" I'm a pretty big OO fan but when I use Perl I don't bother with the OO features once I had looked at th

Re: [GENERAL] Transaction Blocks

2003-07-08 Thread Jay O'Connor
On 2003.07.07 11:56 Mat wrote: > I believe that its more efficient to group INSERT's together and COMMIT > them in groups. > However, I am automatically entering a lot of data and some of its is > not unique. How can I reap the benefits of using BEGIN and COMMIT > without the whole block of transac

[GENERAL] Datatypes and performance

2003-07-04 Thread Jay O'Connor
Couple of questions on datat types and performance 1. varchar vs varchar(2) I created a database schema and based on the test data I had to work with, I couldn't really determine the max size of a lot of string fields so I just left a lot of fields as varchar A comment from a coworker was that t

Re: [GENERAL] problem of upper/lower case in table names

1998-11-17 Thread Jay O'Connor
ike to know who's fault it is ( mine or postgres ) >Thanks for your advices & help I've run into the same problem just creating a table with a name including an uppercase. The name gets converted to all lowercase but then I seem unable to DROP the table. >NB : i'm using postg