Temporal Preferences

There are several temporal preferences in PSQL.

Latest

The desired Date/Time should be as late as possible.

Syntax

PREFERRING 
<column> LATEST [<supremum>, <d>] [, <c>] [<SV-Relation>] 

Example

SELECT * FROM car PREFERRING reg_date LATEST; 

Earliest

The desired Date/Time should be as early as possible.

Syntax

PREFERRING 
<column> EARLIEST [<supremum>, <d>] [, <c>] [<SV-Relation>] 

Example

SELECT * FROM car PREFERRING reg_date EARLIEST; 

Later / earlier than

The desired Date/Time should be later or earlier than the denoted Date/Time.

Syntax

PPREFERRING 
<column> LATER THAN <z> [, <d> ] [, <c> ] [<SV-Relation>] 
<column> EARLIER THAN <z> [, <d> ] [, <c> ] [<SV-Relation>] 

Example

SELECT * FROM car PREFERRING reg_date LATER THAN DATE '2012-12-23'; 

SELECT * FROM car PREFERRING reg_date EARLIER THAN DATE '2012-12-23';