Re: Range Types - cache lookup failed for function

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: pgsql-hackers@postgresql.org
Date: 2011-02-07T16:52:51Z
Lists: pgsql-hackers
On Sun, 2011-02-06 at 20:10 +0100, Erik Rijkers wrote:
> I was trying
>     where intrange @> integer
> 
> which admittedly is not in the documentation,
> but does already half work, and would be really
> convenient to have.  As it stands the construct
> seems to fail after ANALYZE, when there is more
> than 1 row:

Thank you for the report! I actually did make some mention of that in
the documentation, albeit brief (in the operators table, using timestamp
as an example).

I have a fix for it. There may still be an issue with the constructors
like range(1,2), so I'll look into it a little more, but an updated
patch should come soon.

Regards,
	Jeff Davis