Error defining composite types and returning ROWTYPEs

Поиск
Список
Период
Сортировка
От Geoffrey Giesemann
Тема Error defining composite types and returning ROWTYPEs
Дата
Msg-id d90vhi$t4e$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: Error defining composite types and returning ROWTYPEs
Список pgsql-general
CREATE TABLE test_table (
   some_column integer,
   another_column text
);

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 $$
DECLARE
   v_single test_table%ROWTYPE;
BEGIN
   SELECT * INTO v_single FROM test_table LIMIT 1;
   RETURN v_single;
END;
$$ LANGUAGE plpgsql;

Gives me:
ERROR:  syntax error at or near "%" at character 65
LINE 2: RETURNS test_table%ROWTYPE AS $$

Can somebody tell me what I'm doing wrong? This is driving me insane.

Geoff

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeffery Reedy
Дата:
Сообщение: Replication
Следующее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: libpq.so.3 problem, PostgreSQL >= 8.0.2 and RPM