carter ck wrote: > > Hi, > > Thanks for reminding me. And the actual number of records is 100,000. > > The table is as following:
And the query? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq