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
"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,
Hi,
I would like to create an index on a table,
specifying an order clause for one of the columns.
CREATE INDEX IDX_GSLOG_EVENT_PLAYER_EVENT_TIME_DESC
ON GSLOG_EVENT(PLAYER_USERNAME,
EVENT_NAME,
EVENT_DATE_CREATED DESC);
which is not a vali
