Doh - I'm stupid. Ignore my question :) Helps if you spell 'average' as 'avg' :)
Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher > Kings-Lynne > Sent: Friday, 20 September 2002 10:03 AM > To: Tom Lane; Zeugswetter Andreas SB SD > Cc: Bruce Momjian; [EMAIL PROTECTED] > Subject: Re: [HACKERS] Proposal for resolving casting issues > > > Will the new casting stuff address this kind of annoyance? > > usa=# select average(octet_length(val)) from users_sessions; > ERROR: Function 'average(int4)' does not exist > Unable to identify a function that satisfies the given argument > types > You may need to add explicit typecasts > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
