"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly