Doh - I'm stupid. Ignore my question :)
Helps if you spell 'average' as 'avg' :)
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Christopher
> Kings-Lynne
> Sent: Friday, 20 September 2002 10:03 AM
> To: Tom Lane; Zeugswetter Andreas SB SD
> Cc: Bruce Momjian; pgsql-hackers@postgresql.org
> 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
>