> --- Bernard Cheung <[EMAIL PROTECTED]> wrote:
> > Thank you, but my intension is to check whether the user supplies
> > NAME when
> > updating the record.
> >
> > For example the trigger shall allow statement 1 and block statement
> > 2:
> >
> > 1. UPDATE COMPANY SET NAME = 'ABC', ADDRESS = '1
Sorry. I realize I slipped an error in my code:
the code is:
---
CREATE TABLE public.imp_test
(
id int8,
value text
) WITHOUT OIDS;
CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test)
RETURNS imp_test AS
'begin
return $1;
end;'
LANGUAGE 'plpgsql' STABLE;
CREAT
