Revision 14223
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1529 | 1529 |
-- |
| 1530 | 1530 |
|
| 1531 | 1531 |
CREATE FUNCTION copy(from_ regtype, to_ text) RETURNS void |
| 1532 |
LANGUAGE sql |
|
| 1532 |
LANGUAGE sql STRICT
|
|
| 1533 | 1533 |
AS $_$ |
| 1534 |
-- must be declared STRICT to handle NULL properly |
|
| 1534 | 1535 |
SELECT util.materialize_query(to_, $$SELECT (NULL::$$||from_||$$).*$$) |
| 1535 | 1536 |
$_$; |
| 1536 | 1537 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: copy(from_ regtype, to_ text): must be declared STRICT to handle NULL properly