aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_ddl_deparse/expected/create_transform.out
blob: 0d1cc360f4ed1c29638447aff0617f9d8e328380 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
--
-- CREATE_TRANSFORM
--
-- Create a dummy transform
-- The function FROM SQL should have internal as single argument as well
-- as return type. The function TO SQL should have as single argument
-- internal and as return argument the datatype of the transform done.
-- pl/plpgsql does not authorize the use of internal as data type.
CREATE TRANSFORM FOR int LANGUAGE SQL (
    FROM SQL WITH FUNCTION varchar_transform(internal),
    TO SQL WITH FUNCTION int4recv(internal));
NOTICE:  DDL test: type simple, tag CREATE TRANSFORM
DROP TRANSFORM FOR int LANGUAGE SQL;