Devuelve el primer o el último identificador de celda QUADBIN de un valor temporal

startValue(tquadbin) → quadbin

endValue(tquadbin) → quadbin

SELECT startValue(tquadbin '480fffffffffffff@2001-01-01');
-- 480fffffffffffff
SELECT endValue(tquadbin '{480fffffffffffff@2001-01-01, 48427fffffffffff@2001-01-02}');
-- 48427fffffffffff

Devuelve el n-ésimo identificador de celda QUADBIN distinto (índice base 1). Devuelve NULL si está fuera de rango.

valueN(tquadbin,integer) → quadbin

SELECT valueN(tquadbin '{480fffffffffffff@2001-01-01, 48427fffffffffff@2001-01-02}', 1);
-- 480fffffffffffff
SELECT valueN(tquadbin '{480fffffffffffff@2001-01-01, 48427fffffffffff@2001-01-02}', 2);
-- 48427fffffffffff
SELECT valueN(tquadbin '480fffffffffffff@2001-01-01', 99);
-- NULL

Devuelve el conjunto de identificadores de celda QUADBIN distintos que toma la trayectoria

getValues(tquadbin) → quadbinset

SELECT getValues(tquadbin '480fffffffffffff@2001-01-01');
-- {480fffffffffffff}
SELECT getValues(tquadbin
  '[480fffffffffffff@2001-01-01, 48427fffffffffff@2001-01-02,
    48a6227affffffff@2001-01-03]');
-- {480fffffffffffff, 48427fffffffffff, 48a6227affffffff}

Devuelve el identificador de celda QUADBIN en un instante dado, usando interpolación de pasos

valueAtTimestamp(tquadbin,timestamptz) → quadbin

SELECT valueAtTimestamp(tquadbin
  '[480fffffffffffff@2001-01-01, 48427fffffffffff@2001-01-05]',
  '2001-01-03');
-- 480fffffffffffff