Jeff Davis <pg...@j-davis.com> writes: > On Sun, 2011-01-30 at 02:55 +0000, Thom Brown wrote: >> postgres=# select '[18,20]'::numrange @> 19; >> ERROR: operator does not exist: numrange @> integer >> LINE 1: select '[18,20]'::numrange @> 19; >> ^ >> HINT: No operator matches the given name and argument type(s). You >> might need to add explicit type casts.
> It's because it doesn't know the type on the right side, and assumes > it's an int4. Well, yeah, it is an int4. The question ought to be phrased "why does the parser fail to promote the int4 to numeric?". There might be some excuse for an "operator is not unique" here, but I don't understand the above failure --- it should be able to use an implicit coercion from int4 to numeric. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers