"Etsuro Fujita" <fujita.ets...@lab.ntt.co.jp> wrote: > I would like to propose single-column sortedness options and > insert appropriate pathkeys into the ForeignPath node based on > these information: > > sorted: Boolean option to specify whether data file is sorted by > a column. > key: Specifies the name of a column by which data file is sorted. > Required when the above option is set to true. > direction: Specifies the sort order: asc or desc. The default is > asc. > nulls: Specifies that nulls sort before or after non-nulls: first > or last. first is the default when direction option is set > desc. When direction option is not set desc, last is the > default. For character-based columns, don't we need to know the collation? -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers