Revision 12243
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2069 | 2069 |
CREATE FUNCTION schema(table_ regclass) RETURNS text |
| 2070 | 2070 |
LANGUAGE sql STABLE |
| 2071 | 2071 |
AS $_$ |
| 2072 |
SELECT nspname::text FROM pg_namespace WHERE oid = (SELECT relnamespace FROM pg_class WHERE oid = $1) |
|
| 2072 |
SELECT nspname::text |
|
| 2073 |
FROM pg_class |
|
| 2074 |
JOIN pg_namespace ON pg_namespace.oid = relnamespace |
|
| 2075 |
WHERE pg_class.oid = $1 |
|
| 2073 | 2076 |
$_$; |
| 2074 | 2077 |
|
| 2075 | 2078 |
|
Also available in: Unified diff
schemas/util.sql: schema(regclass): use joins instead of nested SELECTs for consistency with schema(regtype)