Re: Use of RETURN in pl/pgsql function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Eckermann <jeckermann(at)verio(dot)net>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Use of RETURN in pl/pgsql function
Date: 2001-02-07 18:47:52
Message-ID: 6923.981571672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff Eckermann <jeckermann(at)verio(dot)net> writes:
> I thought (based on recent posts) that this use of RETURN is allowed, but
> when trying an insert to report_table, I get the following error:
> ERROR: control reaches end of trigger procedure without RETURN

Looks to me like you didn't cover the case where billing_frequency is
not any of the values you tested for. Maybe you just want to raise
an error in that case...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-07 19:37:10 Bug reports for 7.1 beta?
Previous Message Jeff Eckermann 2001-02-07 18:20:36 Use of RETURN in pl/pgsql function