On Thu, 14 Mar 2002, Zhang, Anna wrote: > gtld_analysis=# explain SELECT NETBLOCK_START > gtld_analysis-# FROM GTLD_OWNER > gtld_analysis-# WHERE NETBLOCK_START = -2147483648;
You might want to try the same query but with the constant integer enclosed in single quotes. I find that (at least for int8) this changes the behaviour wrt index usage -- most probably due to automatic typecasting in the postgresql SQL parser. Hope this helps... Tycho -- Tycho Fruru [EMAIL PROTECTED] Users' impressions of different operating systems, expressed as emoticons: Linux: :) Windows: XP ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
