select from a dynamic table name

Поиск
Список
Период
Сортировка
От Jason Kwok
Тема select from a dynamic table name
Дата
Msg-id 000e01c1636b$c466b380$0201a8c0@newhonest.com
обсуждение исходный текст
Ответы Re: select from a dynamic table name  (David Stanaway <david@netventures.com.au>)
Список pgsql-sql
Since I could return a rowset (some records) from a function of pgsql or
plpgsql, I saved all the records into a temp file. Then I want to get the
rowset by another select statement from this temp table with dynamic name,
could I do something like the folowing :

select * from a_dynamic_table_name ?

If the a_dynamic_table_name could be specified as a function, it would be
great, because inside the function I could insert the needed rows into the
temp file and then return its name for the select statement. Is this
possible?

==
====
Best Regards
Jason Kwok
==============
====


---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.292 / Virus Database: 157 - Release Date: 2001/10/26



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

Предыдущее
От: "David M. Richter"
Дата:
Сообщение: Re: View consistency
Следующее
От: domingo@dad-it.com (Domingo Alvarez Duarte)
Дата:
Сообщение: Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql