substrait-extensions 0.87.0

Packaged Substrait Extension Files
Documentation
### SUBSTRAIT_SCALAR_TEST: v1.0
### SUBSTRAIT_INCLUDE: '/extensions/functions_datetime.yaml'

# timestamps: examples using the timestamp type
gt('2016-12-31T13:30:15'::ts, '2017-12-31T13:30:15'::ts) = false::bool
gt('2018-12-31T13:30:15'::ts, '2017-12-31T13:30:15'::ts) = true::bool

# timestamp_tz: examples using the timestamp_tz type
gt('1999-01-08T01:05:05-08:00'::tstz, '1999-01-08T04:05:06-05:00'::tstz) = false::bool
gt('1999-01-08T01:05:07-08:00'::tstz, '1999-01-08T04:05:06-05:00'::tstz) = true::bool

# date: examples using the date type
gt('2020-12-30'::date, '2020-12-31'::date) = false::bool
gt('2020-12-31'::date, '2020-12-30'::date) = true::bool

# interval: examples using the interval type
gt('P7D'::iday, 'P6D'::iday) = true::bool
gt('P5D'::iday, 'P6D'::iday) = false::bool
gt('P5Y'::iyear, 'P6Y'::iyear) = false::bool
gt('P7Y'::iyear, 'P6Y'::iyear) = true::bool

# null_input: examples with null args
gt(null::iday?, 'P5D'::iday) = null::bool?
gt(null::date?, '2020-12-30'::date) = null::bool?
gt(null::ts?, '2018-12-31T13:30:15'::ts) = null::bool?