Weird behaviour of = ANY ( SUBQUERY ) ?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Weird behaviour of = ANY ( SUBQUERY ) ?
Date: 2009-09-30 10:05:50
Message-ID: 20090930100550.GA2667@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Version - 8.5devel.

Why this doesn't work:

# SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) );
ERROR: operator does not exist: integer = integer[]
LINE 1: SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) );
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

direct usage of array of course works:
# select 1 = any ( '{1,2}'::int4[] );
?column?
----------
t
(1 row)

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Edinei 2009-09-30 11:11:50 BUG #5090: erro
Previous Message ajay labade 2009-09-30 09:26:29 Re: Reg: 25P02, current transaction is aborted, commands ignored until end of transaction block