Postgres Pro
Downloads
Home   >   mailing lists

Re: cast affects use of indexes ? - Mailing list pgsql-general

From Tom Lane
Subject Re: cast affects use of indexes ?
Date
Msg-id 20321.1216879152@sss.pgh.pa.us
Whole thread Raw
In response to cast affects use of indexes ?  (Alex Vinogradovs <AVinogradovs@clearpathnet.com>)
List pgsql-general
Tree view 
Alex Vinogradovs <AVinogradovs@clearpathnet.com> writes:
> Is it possible to make it work properly without
> use of explicit casts ? Thanks!

Read
http://www.postgresql.org/docs/8.3/static/xindex.html
particularly the discussion of cross-type index operators.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: contrib catalogs
Next
From: "Harvey, Allan AC"
Date:
Subject: Re: 8.3.3 regression test on SCO 5.0.7