pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)  latest in thread

Message-ID: <000e01c1636b$c466b380$0201a8c0@newhonest.com>
Permalink:  ../000e01c1636b$c466b380$0201a8c0@newhonest.com/
Also on:    postgresql.org/message-id/000e01c1636b$c466b380$0201a8c0@newhonest.com

 · 

reply

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