On 11/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: > Merlin Moncure <[EMAIL PROTECTED]> writes: > > esp=# select xmin, xmax, lastmod from parts_order_line_file where > > prl_combined_key = > > esp-# ' 00136860' and prl_seq_no in (20, 23); > > xmin | xmax | lastmod > > -----------+------+------------------------- > > 584527952 | 0 | 2005-09-15 11:17:17.062 > > 584527961 | 0 | 2005-09-15 11:17:17.187 > > (2 rows) > > I think you need to try this with enable_indexscan = 0; it should be
right, I missed that! esp=# select prl_combined_key, prl_seq_no, xmin, xmax, lastmod from parts_order_line_file where prl_combined_key = ' 00136860' and prl_seq_no in (20, 23); prl_combined_key | prl_seq_no | xmin | xmax | lastmod ------------------+------------+-----------+------+------------------------- 00136860 | 20 | 584527952 | 0 | 2005-09-15 11:17:17.062 00136860 | 20 | 584412245 | 0 | 2005-09-15 09:31:35.381 00136860 | 23 | 584527961 | 0 | 2005-09-15 11:17:17.187 00136860 | 23 | 584415243 | 0 | 2005-09-15 09:32:18.898 merlin ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq