Guys, I've got a table with an indexed column of a numeric user type (implemented in C). When I run a select on that table in a form of :
select * from sometable where column = 89464; sequential scan is used... When I rewrite the query to use cast like this : select * from sometable where column = 89464::mytype; bitmap index scan and bitmap heap scan are used. Is it possible to make it work properly without use of explicit casts ? Thanks! Best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general