distance_tnumber_number nad_tbox_tbox nad_tnumber_number nad_tnumber_tbox nad_tnumber_tnumber

nad_tbox_tbox() double nad_tbox_tbox ( const TBox *  box1, const TBox *  box2  ) Return the nearest approach distance between the temporal boxes. Parameters [in] box1,box2 Temporal boxes Returns On error return infinity Note Function called when using indexes for k-nearest neighbor queries for temporal numbers. Therefore, it must satisfy the following conditions (1) the actual distance is always greater than or equal to the estimated distance and (2) the index returns the tuples in order of increasing estimated distance. https://www.postgresql.org/message-id/CA%2BTgmoauhLf6R07sAUzQiRcstF5KfRw7nwiWn4VZgiSF8MaQaw%40mail.gmail.com @csqlfn NAD_tbox_tbox() The function returns a double for both integer and float boxes