Re: upper case constraint?

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