hi, If you create a table with one of the columns defined as int8, then the index created on this column does not work. When I use explain to see the plan, it is always seq scan instead of index scan as one would expect. Other types of columns work fine (int4, string ...).
Hao
===================================================================== WARNING -This e-mail, including any attachments, is for the personal use of the recipient(s) only. Republication and re-dissemination, including posting to news groups or web pages, is strictly prohibited without the express prior consent of Thomson Legal & Regulatory Limited ACN 64 058 914 668 =====================================================================
---------------------------(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
