On Mon, 27 Nov 2006, Shawn Tayler wrote: > > The following bug has been logged online: > > Bug reference: 2788 > Logged by: Shawn Tayler > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.5 > Operating system: Linux 2.6.17 > Description: Create Function operator Broken? > Details: > > I have been through the online DOC's the FAQ and can find nothing wrong with > it. So I am thinking its a bug. > > CREATE FUNCTION default_status() returns null AS
Do you mean returns void? I believe the issue is that returns null starts the "returns null on null input" function attribute. > 'BEGIN > update status set wc to false, np to false, elk to false, sp1 to false, > sp2 to false, wc_rep to false, np_rep to false, elk_rep to false, sp1_rep to > false, > sp2_rep to false; > END;' > language 'sql'; The above body isn't valid for an sql body as well. Sql functions won't have a begin or end, and I don't think those "to"s will be valid either. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate