There are several temporal preferences in PSQL.
The desired Date/Time should be as late as possible.
PREFERRING
<column> LATEST [<supremum>, <d>] [, <c>] [<SV-Relation>]
SELECT * FROM car PREFERRING reg_date LATEST;
The desired Date/Time should be as early as possible.
PREFERRING
<column> EARLIEST [<supremum>, <d>] [, <c>] [<SV-Relation>]
SELECT * FROM car PREFERRING reg_date EARLIEST;
The desired Date/Time should be later or earlier than the denoted Date/Time.
PPREFERRING
<column> LATER THAN <z> [, <d> ] [, <c> ] [<SV-Relation>]
<column> EARLIER THAN <z> [, <d> ] [, <c> ] [<SV-Relation>]
SELECT * FROM car PREFERRING reg_date LATER THAN DATE '2012-12-23';
SELECT * FROM car PREFERRING reg_date EARLIER THAN DATE '2012-12-23';
Table of Contents