From: Jason Kwok <jason@newhonest.com>
To: pgsql-sql@postgresql.org
Subject: select from a dynamic table name
Date: Fri, 2 Nov 2001 14:58:24 +0800
Message-ID: <000e01c1636b$c466b380$0201a8c0@newhonest.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jason@newhonest.com
Subject: Re: select from a dynamic table name
In-Reply-To: <000e01c1636b$c466b380$0201a8c0@newhonest.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox