[GENERAL] Normalization and regexp

Hi, Since Canada Post hasn't programmed their automated web tools for calculating transportation costs to work with anything outside of Windows Internet Explorer, I'm obliged to write a web based program optimized for all those *other* browsers, myself. Part of this task requires that I set up

Re: [GENERAL] Calculating total amounts per clientid

Thanks for responding. That was the tip I needed. Regards, Mark On Sat, 13 Dec 2003 16:36:32 -0300 Martin Marques <[EMAIL PROTECTED]> wrote: > El Sáb 13 Dic 2003 16:21, MT escribió: > > Hi, > > > > I have an invoicing system using postgresql. Each time a customer

[GENERAL] Calculating total amounts per clientid

Hi, I have an invoicing system using postgresql. Each time a customer makes a purchase, a new record is inserted into the "cart" table. The "cart" table, among other things, contains a customer_id field and a total for the amount purchased on the particular invoice. Now what I'd like to do is t

[GENERAL] adding fields to a table

Hello, I have a table with a bunch of records already inserted. When I want to add or remove fields from the, what I've done is produce an sql file, add the fields to the create table directive, and add the fields manually to each record to be inserted. Then I do an \i db_name which destroys