Re: subqueries

Поиск
Список
Период
Сортировка
От Roman Neuhauser
Тема Re: subqueries
Дата
Msg-id 20050620090755.GB9956@isis.sigpipe.cz
обсуждение исходный текст
Ответ на Re: subqueries  (Tomasz Grobelny <tomasz@grobelny.oswiecenia.net>)
Список pgsql-general
# tomasz@grobelny.oswiecenia.net / 2005-06-20 01:02:38 +0200:
> I wanted to define a function like this:
> create or replace function fun(...)...
> create temp table qaz as subquery1;
> create temp table wsx as subquery1;
> select * from qaz, wsx;
> language sql;
> but I get postgresql error saying that relation qaz does not exist. Well it
> doesn't when the function is created but it would exist when it would be
> needed. Note that that set of commands I put as function body works just fine
> (just not in a function).

    http://www.postgresql.org/docs/7.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

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

Предыдущее
От: Jacob Atzen
Дата:
Сообщение: Re: Backing up multiple databases
Следующее
От: Milan Krcmar
Дата:
Сообщение: External (asynchronous) notifications of database updates