Inserting values into a variable table

["Greg Quinn" <greg(at)officium(dot)co(dot)za>]

I am creating a function for inserting values into a table.

The problem is the tables have various names, depending on the userid.

 

i.e

 

email_inbox_a608ac4e-5215-4758-905e-78cfb809aebc

 

is for one user, while…

 

email_inbox_c86hce32-4758-905e-gfkk439d83jd

 

is for another.

 

I am trying in my sql, to pass the tablename as a parameter,

 

i.e

 

select * from $1 where messageid  = $2

 

but the compiler is not accepting it. What is recommended?

 

Thank you.

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.15/550 - Release Date: 11/24/2006 5:20 PM