Project

General

Profile

« Previous | Next » 

Revision 13803

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/util.sql: range(numeric, numeric): use util.range instead of numrange to support wraparound ranges (which use a modulus system such as geocoordinates)

View differences:

trunk/schemas/util.sql
3144 3144 
-- Name: range(numeric, numeric); Type: FUNCTION; Schema: util; Owner: -
3145 3145 
--
3146 3146 

  		




  3147
  
  
    
CREATE FUNCTION range(lower numeric, upper numeric) RETURNS numrange


  		




  
  3147
  
    
CREATE FUNCTION range(lower numeric, upper numeric) RETURNS range


  		




  3148
  3148
  
    
    LANGUAGE sql IMMUTABLE


  		




  3149
  3149
  
    
    AS $_$


  		




  3150
  
  
    
SELECT numrange($1, $2, '[]')


  		




  
  3150
  
    
SELECT ($1, $2, '[]')::util.range


  		




  3151
  3151
  
    
$_$;


  		




  3152
  3152
  
    

  		




  3153
  3153
  
    

  		












Also available in:  Unified diff