Inserting values into a variable table

Поиск
Список
Период
Сортировка
От Greg Quinn
Тема Inserting values into a variable table
Дата
Msg-id 000001c710d1$3d424130$6501a8c0@melt
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Integer Question - Does Limit Value Make Sense
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Inserting values into a variable table