Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-13 Thread Jim Nasby
On 12/12/14, 7:16 PM, Tom Lane wrote: Jim Nasby writes: I'd say that array_eq (and probably _cmp) just needs to be taught to fall back to what oper() does, but this part of the commit message gives me pause: "Change the operator search algorithms to look for appropriate btree or hash index

Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-12 Thread Tom Lane
Jim Nasby writes: > I'd say that array_eq (and probably _cmp) just needs to be taught to fall > back to what oper() does, but this part of the commit message gives me pause: > "Change the operator search algorithms to look for appropriate btree or hash > index opclasses, instead of assuming ope

Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-12 Thread Jim Nasby
On 12/9/14, 5:06 PM, Jim Nasby wrote: On 12/9/14, 4:30 PM, Tom Lane wrote: Jim Nasby writes: On 12/9/14, 4:19 PM, Jim Nasby wrote: Is there any particular reason we don't allow comparing char and varchar arrays? If not I'll submit a patch. We're also missing operators on text and varchar

Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-09 Thread Jim Nasby
On 12/9/14, 4:30 PM, Tom Lane wrote: Jim Nasby writes: On 12/9/14, 4:19 PM, Jim Nasby wrote: Is there any particular reason we don't allow comparing char and varchar arrays? If not I'll submit a patch. We're also missing operators on text and varchar arrays. Adding operators would be an

Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-09 Thread Jim Nasby
On 12/9/14, 4:19 PM, Jim Nasby wrote: Is there any particular reason we don't allow comparing char and varchar arrays? If not I'll submit a patch. We're also missing operators on text and varchar arrays. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! ht

Re: [HACKERS] operator does not exist: character varying[] <> character[]

2014-12-09 Thread Tom Lane
Jim Nasby writes: > On 12/9/14, 4:19 PM, Jim Nasby wrote: >> Is there any particular reason we don't allow comparing char and varchar >> arrays? If not I'll submit a patch. > We're also missing operators on text and varchar arrays. Adding operators would be an incorrect fix.

[HACKERS] operator does not exist: character varying[] <> character[]

2014-12-09 Thread Jim Nasby
Is there any particular reason we don't allow comparing char and varchar arrays? If not I'll submit a patch. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To mak