Re: PostgreSQL does CAST implicitely between int andadomain derived from int

Jean-Michel Pouré<jm@poure.com> wrote:

> ... Index Cond: ((tid)::integer = 3)

> ... Index Cond: ((n.vid)::integer = (tn.vid)::integer)

> ... Index Cond: ((ncs.nid)::integer = n.nid)

>  Total runtime: 0.092 ms

Sorry, but I just had to point that out.
I feel much better now.  ;-)

> Does it mean my index is broken and should be rebuilt?

No, probably not.

Just to get another data point, what happens if you run the same query
without taking the index out of the picture, but without the LIMIT or
OFFSET clauses?  An EXPLAIN ANALYZE of that would help understand it
more fully.

-Kevin