Re: Use of RETURN in pl/pgsql function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Use of RETURN in pl/pgsql function
Date
Msg-id 6923.981571672@sss.pgh.pa.us
Whole thread Raw
In response to Use of RETURN in pl/pgsql function  (Jeff Eckermann <jeckermann@verio.net>)
List pgsql-sql
Jeff Eckermann <jeckermann@verio.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


pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Use of RETURN in pl/pgsql function
Next
From: Josh Berkus
Date:
Subject: Bug reports for 7.1 beta?