Re: function problems. - Mailing list pgsql-novice

From Ludwig Lim
Subject Re: function problems.
Date
Msg-id 20021025103456.83735.qmail@web80312.mail.yahoo.com
Whole thread Raw
In response to function problems.  ("Duncan Adams (DNS)" <duncan.adams@vcontractor.co.za>)
List pgsql-novice
Hi :

>
> create function fun_test() RETURNS opaque as '
>         BEGIN
>             INSERT INTO test
> (hos_nam,ser_num,loc,dep,use) VALUES
> (''a'',''b'',0,0,''c'');
>         END;
>         '
> language 'plpgsql';
>

  All trigger functions (i.e functions returning type
opaque) must have either have "RETURN NULL","RETURN
NEW" or "RETURN OLD"


ludwig.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: function problems.
Next
From: Tom Lane
Date:
Subject: Re: function problems.