"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> 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
regression=# select * from pg_proc where proname = 'average';proname | pronamespace | proowner | prolang | proisagg |
prosecdef| proisstrict | proretset | provolatile | pronargs | prorettype | proargtypes | prosrc | probin | proacl
---------+--------------+----------+---------+----------+-----------+-------------+-----------+-------------+----------+------------+-------------+--------+--------+--------
(0 rows)
No, I think you'll get the same error ...
regards, tom lane