Revision 13795
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 3090 | 3090 |
CREATE FUNCTION range(lower numeric, upper numeric) RETURNS numrange |
| 3091 | 3091 |
LANGUAGE sql IMMUTABLE |
| 3092 | 3092 |
AS $_$ |
| 3093 |
SELECT ('['||$1||','||$2||']')::numrange
|
|
| 3093 |
SELECT numrange($1, $2, '[]')
|
|
| 3094 | 3094 |
$_$; |
| 3095 | 3095 |
|
| 3096 | 3096 |
|
Also available in: Unified diff
schemas/util.sql: range(numeric, numeric): use simpler numrange() constructor instead of text input syntax