Revision 12340
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2231 | 2231 |
|
| 2232 | 2232 |
|
| 2233 | 2233 |
-- |
| 2234 |
-- Name: relation_type(character); Type: FUNCTION; Schema: util; Owner: -
|
|
| 2234 |
-- Name: relation_type("char"); Type: FUNCTION; Schema: util; Owner: -
|
|
| 2235 | 2235 |
-- |
| 2236 | 2236 |
|
| 2237 |
CREATE FUNCTION relation_type(relation_type_char character) RETURNS character
|
|
| 2237 |
CREATE FUNCTION relation_type(relation_type_char "char") RETURNS text
|
|
| 2238 | 2238 |
LANGUAGE sql IMMUTABLE |
| 2239 | 2239 |
AS $_$ |
| 2240 | 2240 |
SELECT 'r=>TABLE, v=>VIEW'::hstore -> $1 |
Also available in: Unified diff
bugfix: schemas/util.sql: relation_type(character): must use "char" type for single character, as character actually allows multiple characters. corrected return type.