Inserting values into a variable table - Mailing list pgsql-novice

From Greg Quinn
Subject Inserting values into a variable table
Date
Msg-id 000001c710d1$3d424130$6501a8c0@melt
Whole thread Raw
Responses Re: Inserting values into a variable table  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Inserting values into a variable table  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-novice

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

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Integer Question - Does Limit Value Make Sense
Next
From: Richard Broersma Jr
Date:
Subject: Re: Inserting values into a variable table