Re: function problems.

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
Cc: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: function problems.
Date: 2002-10-25 10:34:56
Message-ID: 20021025103456.83735.qmail@web80312.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nicolas ... 2002-10-25 13:32:13 Views
Previous Message Oliver Elphick 2002-10-25 09:15:26 Re: function problems.