You could try writing another function to do the select, and construct the query using string manipulation...
Chris
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