> There doesn't seem to be a way to turn this off except by explicitly
> editing the SQL statement to remove the ASC clause. Can we have it not
> enabled by default or if we must -- allow this to be unchecked.
Thanks, Rigina.
The PostgreSQL documentation mentioned:
For index methods that support ordered scans (currently, only B-tree),
the optional clauses ASC, DESC, NULLS FIRST, and/or NULLS LAST can be specified
to reverse the normal sort direction of the index.
This is my mistake.
I will fix it ASAP.
-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn