On Tue, 25 Sep 2001, Gowey, Geoffrey wrote:
> Just wondering if anyone knows off hand how to make it so all inserts on a
> column will wind up being tranparently stored as uppercase (ex: ee1234567 =
> EE1234567).
Probably a trigger, before update/insert on table:
create function gouppertable_col() returns opaque as '
begin
NEW.col := upper(NEW.col);
return NEW;
end;
' language 'plpgsql';
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
