Re: can't win - Mailing list pgsql-general

From Jeff Rogers
Subject Re: can't win
Date
Msg-id 200406182040.i5IKer928680@findlaw.com.
Whole thread Raw
In response to Re: can't win  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
>> Is there any way I can get the best of both worlds?
>
> Hmm, how about a multiple column index on (topic, created)?  You might
> need to use
>  select * from articles where topic='Example' order by topic desc, created
>  desc limit 5;
> to get it to use the index though.

That works beautifully, thanks!

-J



pgsql-general by date:

Previous
From: Eduardo Pérez Ureta
Date:
Subject: Re: INSERT ON DUPLICATE KEY UPDATE
Next
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: INSERT ON DUPLICATE KEY UPDATE