I have a question about using index in order statement. - Mailing list pgsql-bugs

Question:=20
I have a question about using index in order statement.
Why index ix_2 work by Seq Scan and index ix_3 work by Index Scan.

Example :

ix_2 condition :
When I try

  explain
  select * from a_test=20
  order by code_ desc

Postgresql response=20
  Sort  (cost=3D100001815.08..100001852.56 rows=3D14990 width=3D56)
    Sort Key: code_
    ->  Seq Scan on a_test  (cost=3D100000000.00..100000260.90 rows=3D14990=
 width=3D56)

ix_3 condition :
When I try

  explain
  select * from a_test=20
  order by lower(code_) desc

Postgresql response=20
    Index Scan using ix_3 on a_test  (cost=3D0.00..769.27 rows=3D14990 widt=
h=3D18)
=20=20=20=20

Table schema :

CREATE TABLE a_test
(
  t_key_ bigint NOT NULL,
  code_ character varying(15)
)
WITH (OIDS=3DTRUE);
ALTER TABLE a_test OWNER TO postgres;

CREATE INDEX ix_2
  ON a_test
  USING btree
  (code_ DESC);

CREATE INDEX ix_3
  ON a_test
  USING btree
  (lower(code_::text) DESC);