Re: Inserting values into a variable table

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Greg Quinn <greg(at)officium(dot)co(dot)za>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Inserting values into a variable table
Date: 2006-11-25 22:23:18
Message-ID: 171262.87028.qm@web31801.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
> email_inbox_a608ac4e-5215-4758-905e-78cfb809aebc
> is for one user, while…
> email_inbox_c86hce32-4758-905e-gfkk439d83jd
> is for another.
> select * from $1 where messageid = $2
> but the compiler is not accepting it. What is recommended?

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

Is this a question about mySQL?

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2006-11-25 22:48:30 Re: Inserting values into a variable table
Previous Message Greg Quinn 2006-11-25 20:35:25 Inserting values into a variable table