Re: [SQL] CREATE INDEX with order clause

2006-02-03 Thread Ragnar
On Wed, 2006-02-01 at 10:46 -0500, Daniel Caune wrote: > Hi, > [snip need for reverse-sort operator class] > > SELECT GAME_CLIENT_VERSION > FROM GSLOG_EVENT > WHERE PLAYER_USERNAME = ? > AND EVENT_NAME = ? > AND EVENT_DATE_CREATED < ? > ORDER BY EVENT_DATE_CREATED DESC > LIMIT

Re: [SQL] CREATE INDEX with order clause

2006-02-01 Thread Tom Lane
"Daniel Caune" <[EMAIL PROTECTED]> writes: > I would like to create an index on a table, specifying an order clause > for one of the columns. Search the archives for discussions of reverse-sort operator classes (you might also get hits on the shorthand "opclass"). regards,