I have created a rule to update a char(19) field from a varchar(32) field.
I don't mind if half the field is cut out, I just want to copy the first
19 characters. Here's what I have
... update products set company=NEW.company;
company is char(19);
NEW.company is varchar(32);
Any suggestions on making this work?
pgsql-sql by date
|Next:||From: The Hermit Hacker||Date: 2000-01-18 17:20:08|
|Subject: Ordering a date_part() query ...|
|Previous:||From: omid omoomi||Date: 2000-01-18 10:48:22|
|Subject: Re: [SQL] Ordering a date_part() query ...|