On Oct 25, 2008, at 05:35, Tom Lane wrote:
Seems to be fixed in HEAD:
regression=# SELECT '{foo}'::name[] <> '{bar}'::name[];
ERROR: operator is only a shell: name[] <> name[]
LINE 1: SELECT '{foo}'::name[] <> '{bar}'::name[];
Great. Is it something that could be backported, or is it not wor
"David E. Wheeler" <[EMAIL PROTECTED]> writes:
> Great. Is it something that could be backported, or is it not worth it?
Not worth it IMO.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.p
"David E. Wheeler" <[EMAIL PROTECTED]> writes:
> I ran into this error on 8.2 a while ago, and just figured out what
> was causing it. Here's a quick example on 8.2:
Seems to be fixed in HEAD:
regression=# SELECT '{foo}'::name[] <> '{bar}'::name[];
ERROR: operator is only a shell: name[] <> na
Howdy,
I ran into this error on 8.2 a while ago, and just figured out what
was causing it. Here's a quick example on 8.2:
BEGIN;
-- Compare name[]s more or less like 8.3 does.
CREATE OR REPLACE FUNCTION namearray_text(name[])
RETURNS TEXT AS 'SELECT textin(array_out($1));'
LANGUAGE sql IMMUT
