Revision 10986
Added by Aaron Marcuse-Kubitza about 11 years ago
schemas/util.sql | ||
---|---|---|
651 | 651 |
|
652 | 652 |
|
653 | 653 |
-- |
654 |
-- Name: col__min(col_ref); Type: FUNCTION; Schema: util; Owner: - |
|
655 |
-- |
|
656 |
|
|
657 |
CREATE FUNCTION col__min(col col_ref) RETURNS integer |
|
658 |
LANGUAGE sql STABLE |
|
659 |
AS $_$ |
|
660 |
SELECT util.eval2val($$ |
|
661 |
SELECT $$||quote_ident($1.name)||$$ |
|
662 |
FROM $$||$1.table_||$$ |
|
663 |
ORDER BY $$||quote_ident($1.name)||$$ ASC |
|
664 |
LIMIT 1 |
|
665 |
$$, NULL::integer) |
|
666 |
$_$; |
|
667 |
|
|
668 |
|
|
669 |
-- |
|
654 | 670 |
-- Name: col_comment(col_ref); Type: FUNCTION; Schema: util; Owner: - |
655 | 671 |
-- |
656 | 672 |
|
Also available in: Unified diff
schemas/util.sql: added col__min()