Selecting from a dynamic name - Mailing list pgsql-sql

From Jason Kwok
Subject Selecting from a dynamic name
Date
Msg-id 001001c17948$c916b7c0$0201a8c0@newhonest.com
Whole thread Raw
Responses Re: Selecting from a dynamic name  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-sql
I have asked this question before, but still I'm stuck.
How can I select from a table with a name that's returned by a function?
 
eg : I have a function named tablename() which return 'mytable'
If I already have a table called mytable, can I :
 
select * from tablename();   
 
pgadmin2 returns an error :
ERROR : parser : parse error at or near "("
 
==
====
Best Regards
Jason Kwok
==============
====
 

---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.303 / Virus Database: 164 - Release Date: 2001/11/24

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Check for table existence
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Selecting from a dynamic name