Geoffrey Giesemann <geoffwa(at)iinet(dot)net(dot)au> writes:
> CREATE TYPE test_type as (
> some_type test_table.some_column%TYPE
> );
> Gives me:
> ERROR: syntax error at or near "%" at character 62
> LINE 2: some_type test_table.some_column%TYPE
> I also can't define rowtypes as return types on functions:
> CREATE OR REPLACE FUNCTION get_test_table_single()
> RETURNS test_table%ROWTYPE AS $$
%ROWTYPE is a plpgsql-ism, not a SQL construct. %TYPE isn't a SQL
construct either --- AFAIR we only support it in the very limited
context of CREATE FUNCTION's argument and result type declarators.
regards, tom lane