Revision 13790
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 4479 | 4479 |
|
| 4480 | 4480 |
|
| 4481 | 4481 |
-- |
| 4482 |
-- Name: ~(numeric, numeric); Type: FUNCTION; Schema: util; Owner: - |
|
| 4483 |
-- |
|
| 4484 |
|
|
| 4485 |
CREATE FUNCTION "~"(lower numeric, upper numeric) RETURNS numrange |
|
| 4486 |
LANGUAGE sql IMMUTABLE |
|
| 4487 |
AS $_$ |
|
| 4488 |
SELECT ('['||$1||','||$2||']')::numrange
|
|
| 4489 |
$_$; |
|
| 4490 |
|
|
| 4491 |
|
|
| 4492 |
-- |
|
| 4482 | 4493 |
-- Name: all_same(anyelement); Type: AGGREGATE; Schema: util; Owner: - |
| 4483 | 4494 |
-- |
| 4484 | 4495 |
|
| ... | ... | |
| 4607 | 4618 |
|
| 4608 | 4619 |
|
| 4609 | 4620 |
-- |
| 4621 |
-- Name: ~; Type: OPERATOR; Schema: util; Owner: - |
|
| 4622 |
-- |
|
| 4623 |
|
|
| 4624 |
CREATE OPERATOR ~ ( |
|
| 4625 |
PROCEDURE = "~", |
|
| 4626 |
LEFTARG = numeric, |
|
| 4627 |
RIGHTARG = numeric |
|
| 4628 |
); |
|
| 4629 |
|
|
| 4630 |
|
|
| 4631 |
-- |
|
| 4610 | 4632 |
-- Name: map; Type: TABLE; Schema: util; Owner: -; Tablespace: |
| 4611 | 4633 |
-- |
| 4612 | 4634 |
|
Also available in: Unified diff
schemas/util.sql: added ~ operator for ranges