bbox_expand datum_collinear datumsegm_interpolate datumsegm_locate ensure_increasing_timestamps ensure_valid_tinstarr ensure_valid_tinstarr_common float_collinear floatsegm_interpolate floatsegm_locate intersection_tcontseq_tdiscseq intersection_tdiscseq_tcontseq intersection_tdiscseq_tdiscseq intersection_tinstant_tsequence intersection_tsequence_tinstant synchronize_tsequence_tsequence tcontseq_find_timestamptz tcontseq_to_discrete tcontseq_to_linear tcontseq_to_step tdiscseq_find_timestamptz tdiscseq_set_interp tfloatsegm_intersection_value tinstant_to_tsequence tinstant_to_tsequence_free tinstarr_normalize tnumbersegm_intersection tnumberseq_cont_twavg tnumberseq_disc_twavg tnumberseq_integral tnumberseq_shift_scale_value tnumberseq_shift_scale_value_iter tnumberseq_twavg tnumberseq_valuespans tpointseq_make_coords tsegment_intersection tsegment_intersection_value tsegment_value_at_timestamptz tseqarr2_to_tseqarr tsequence_cmp tsequence_compact tsequence_copy tsequence_duration tsequence_end_timestamptz tsequence_eq tsequence_from_base_tstzset tsequence_from_base_tstzspan tsequence_hash tsequence_in tsequence_insts_p tsequence_join tsequence_join_test tsequence_make tsequence_make_exp tsequence_make_exp1 tsequence_make_free tsequence_make_free_exp tsequence_make_valid tsequence_max_inst tsequence_max_val tsequence_min_inst tsequence_min_val tsequence_minmax_inst tsequence_norm_test tsequence_out tsequence_restart tsequence_segments tsequence_segments_iter tsequence_seqs tsequence_set_interp tsequence_set_tstzspan tsequence_shift_scale_time tsequence_shift_scale_time_iter tsequence_start_timestamptz tsequence_subseq tsequence_time tsequence_timestamps tsequence_timestamps_iter tsequence_to_string tsequence_value_at_timestamptz tsequence_values_p tstepseq_to_linear tstepseq_to_linear_iter

tnumbersegm_intersection() int tnumbersegm_intersection ( Datum  start1, Datum  end1, Datum  start2, Datum  end2, meosType  basetype, TimestampTz  lower, TimestampTz  upper, TimestampTz *  t1, TimestampTz *  t2  ) Compute the intersection, if any, of two segments of temporal sequences. These functions suppose that the instants are synchronized, i.e., start1->t = start2->t and end1->t = end2->t. The functions return true if there is an intersection at the middle of the segments, i.e., they return false if they intersect at a bound. If they return true, they also return in the output parameter t the intersection timestamp. The two values taken by the segments at the intersection timestamp t are equal up to the floating point precision. For the temporal point case we cannot use the PostGIS functions lw_dist2d_seg_seg and lw_dist3d_seg_seg since they do not take time into consideration and would return, e.g., that the two segments [Point(1 1)@t1, Point(3 3)@t2] and [Point(3 3)@t1, Point(1 1)@t2] intersect at Point(1 1), instead of Point(2 2). These functions are used to add intermediate points when lifting operators, in particular for temporal comparisons such as tfloat <comp> tfloat where <comp> is <, <=, ... since the comparison changes its value before/at/after the intersection point. Return 1 or 2 if two temporal number segments intersect during the the period defined by the output timestamps, return 0 otherwise Parameters [in] start1,end1 Values defining the first segment [in] start2,end2 Values defining the second segment [in] basetype Base type of the values [in] lower,upper Timestamps defining the segments [out] t1,t2 Timestamps defining the resulting period, may be equal Note Only the intersection inside the segments is considered