Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group