| From: | Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr> |
|---|---|
| To: | Mario Soto Cordones <msotocl(at)gmail(dot)com> |
| Cc: | Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Immutable attributes? |
| Date: | 2005-04-26 13:54:51 |
| Message-ID: | 20050426135451.GA31623@nic.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 26, 2005 at 09:49:05AM -0400,
Mario Soto Cordones <msotocl(at)gmail(dot)com> wrote
a message of 45 lines which said:
> Hi for all , plese a question ,this function can be write in pl/pgsql ???????
I do not understand, it IS pl/pgsql.
> > CREATE OR REPLACE FUNCTION check_immutable() RETURNS TRIGGER
> > AS 'BEGIN
> > IF NEW.id != OLD.id OR NEW.created != OLD.created THEN
> > RAISE EXCEPTION ''Change not allowed in that table'';
> > END IF;
> > RETURN NEW;
> > END;'
> > LANGUAGE PLPGSQL;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard_D_Levine | 2005-04-26 13:58:49 | Re: UltraSPARC versus AMD |
| Previous Message | Mario Soto Cordones | 2005-04-26 13:49:05 | Re: Immutable attributes? |