A question about "table function"

Поиск
Список
Период
Сортировка
От Yuan Lin
Тема A question about "table function"
Дата
Msg-id b562uc$1nul$1@news.hub.org
обсуждение исходный текст
Ответы Re: A question about "table function"
Список pgsql-general
hi, all:

   When I see the following definitions from postgresql document. I am
completely puzzeled.

CREATE TABLE foo (fooid int, foosubid int, fooname text);

>> As I say it, foo is already a set of columns.

CREATE FUNCTION getfoo(int) RETURNS setof foo AS '
    SELECT * FROM foo WHERE fooid = $1;
' LANGUAGE SQL;

>> here return type should be "setof setof foo".

----------------------------------------------------------------------------
-----------------
Can I rewrite the definition as follows:

CREATE TYPE foo (fooid int, foosubid int, fooname text);

CREATE FUNCTION getfoo(int) RETURNS setof foo AS '
    SELECT * FROM foo WHERE fooid = $1;
' LANGUAGE SQL;

----------------------------------------------------------------------------
-------------------

any comments are appriciate.

JACK DULL




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

Предыдущее
От: "Kev Martin"
Дата:
Сообщение: newbie going round in circle
Следующее
От: Trevor Bylsma
Дата:
Сообщение: postmaster has high CPU (system) utilization