Hello,
>> CREATE DOMAIN test_domain
>> AS varchar(64)
>> NOT NULL;
>> CREATE TYPE test_type AS
>>("Id" int4,
>> "Data" test_domain);
>> CREATE OR REPLACE FUNCTION union_test()
>> RETURNS SETOF test_type AS
>> $BODY$
>> select 1 as "Id", 'string1'::test_domain as "Data"
>> u
Ivan <[EMAIL PROTECTED]> writes:
> CREATE DOMAIN test_domain
> AS varchar(64)
> NOT NULL;
> CREATE TYPE test_type AS
>("Id" int4,
> "Data" test_domain);
> CREATE OR REPLACE FUNCTION union_test()
> RETURNS SETOF test_type AS
> $BODY$
> select 1 as "Id", 'string1'::test_domain a
Hello,
PostgreSQL 8.1beta3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
Windows XP SP2
The following query
CREATE DOMAIN test_domain
AS varchar(64)
NOT NULL;
CREATE TYPE test_type AS
("Id" int4,
"Data" test_domain);
CREATE OR REPLACE FUNCTION union_test
