Revision 8189
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 961 | 961 |
|
| 962 | 962 |
|
| 963 | 963 |
-- |
| 964 |
-- Name: type_qual(anyelement); Type: FUNCTION; Schema: util; Owner: - |
|
| 965 |
-- |
|
| 966 |
|
|
| 967 |
CREATE FUNCTION type_qual(value anyelement) RETURNS text |
|
| 968 |
LANGUAGE sql IMMUTABLE |
|
| 969 |
AS $_$ |
|
| 970 |
SELECT CASE WHEN $1 IS NULL THEN '' ELSE $$ NOT NULL$$ END |
|
| 971 |
$_$; |
|
| 972 |
|
|
| 973 |
|
|
| 974 |
-- |
|
| 964 | 975 |
-- Name: typeof(text, regtype); Type: FUNCTION; Schema: util; Owner: - |
| 965 | 976 |
-- |
| 966 | 977 |
|
Also available in: Unified diff
schemas/util.sql: Added type_qual()