Re: [HACKERS] quirk of array type processing

2003-09-10 Thread Greg Stark
On third though ignore this whole thread. I can't read. sigh. -- greg ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] quirk of array type processing

2003-09-10 Thread Greg Stark
On second thought, it does cause a problem: db=> create table aa (aa integer[]); CREATE TABLE db=> select distinct(array_length(aa)) from aa; ERROR: function array_upper(integer[]) does not exist HINT: No function matches the given name and argument types. You may need to add explicit typecas

[HACKERS] quirk of array type processing

2003-09-10 Thread Greg Stark
I'm not sure if this should be considered a bug or not. At least in my case it doesn't cause a problem. I think it could always be worked around with explicit casts in any case, it just seems... wrong: db=> create or replace function array_length(integer[]) returns integer as 'SELECT array_up