Thanks guys, I've cracked it now... yeah, a lot of syntax errors, but to be honest, I never got to look at the pl syntax page. Thanks to Jakub for the link, it helped solve the problem...
thanks again.. Geoff -----Original Message----- From: Robert Treat [mailto:[EMAIL PROTECTED]] Sent: 11 December 2002 15:57 To: [EMAIL PROTECTED] Cc: Pgsql-Admin (E-mail) Subject: Re: [ADMIN] Function Problem On Wed, 2002-12-11 at 07:38, Geoff wrote: > > RETURN NULL; > > END > > ' LANGUAGE 'plpgsql' ; > Look over Jakub's email, it's on the right track. FWIW, you also need a ; after your END statement, which I believe is the actual error your seeing. Robert Treat ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])