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';