Thread: Question on indexes

Hi,
Can anyone show me a simple way of creating an index
in PostGre like that:
create index indName on someTable(someIntColumn DESC)
?

Thanks In Advance,
Emil

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Emil Rachovsky wrote:
>
> Hi,
> Can anyone show me a simple way of creating an index
> in PostGre like that:
> create index indName on someTable(someIntColumn DESC)
> ?

Not using that particular syntax, but you can do that if you create the
appropiate operator classes.  Note that if you want to use btree index
on a single column, you don't need to have a descending index, because
btree indexes can be scanned in either direction.  The opclass trick is
only needed if you want to have a multicolumn index.  (I guess in the
other access methods it doesn't make much sense to think of descending
indexes.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;