Index Problem - Mailing list pgsql-sql

From Kim Yunhan
Subject Index Problem
Date
Msg-id 20010209145408.HM.40000000001Vhp4@www5.hanmail.net
Whole thread Raw
Responses Re: Index Problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I want to query this...
--> SELECT * FROM bbs ORDER BY ref desc, step ASC LIMIT 12; 

this query doesn't refer the index that made by this query.
--> CREATE INDEX idx_bbs ON bbs (ref, step);

but, i change the query that "ref desc" to "ref asc".
then query refer the index, and i can see a result very fast. :-(

so, i want to view an result that one column ordered by ascending, and oterh column ordered by descending using index.
what do i do?
how make an index?




==================================================

==================================================
우리 인터넷, Daum
평생 쓰는 무료 E-mail 주소 한메일넷
지구촌 한글 검색서비스 Daum FIREBALL
http://www.daum.net


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: parse error in create index
Next
From: Tom Lane
Date:
Subject: Re: Index Problem