Re: [HACKERS] Quirk

2006-12-11 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > I suspect this is unnecessary, that the only reason cursors can't hold locks > is because we don't support the kind of read-write operations that clients may > expect to be able to issue against read-write cursors? I think the rationale is that the SQL s

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