Project

General

Profile

« Previous | Next » 

Revision 14222

schemas/util.sql: added copy(from_ regtype, to_ text)

View differences:

trunk/schemas/util.sql
1525 1525

  
1526 1526

  
1527 1527
--
1528
-- Name: copy(regtype, text); Type: FUNCTION; Schema: util; Owner: -
1529
--
1530

  
1531
CREATE FUNCTION copy(from_ regtype, to_ text) RETURNS void
1532
    LANGUAGE sql
1533
    AS $_$
1534
SELECT util.materialize_query(to_, $$SELECT (NULL::$$||from_||$$).*$$)
1535
$_$;
1536

  
1537

  
1538
--
1528 1539
-- Name: copy_data(regclass, regclass); Type: FUNCTION; Schema: util; Owner: -
1529 1540
--
1530 1541

  

Also available in: Unified diff