From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Greg Quinn <greg(at)officium(dot)co(dot)za> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Inserting values into a variable table |
Date: | 2006-11-25 22:48:30 |
Message-ID: | 20061125144343.H77387@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sat, 25 Nov 2006, Greg Quinn wrote:
> 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?
You can't use arguments directly as a replacement for the table name in
sql or plpgsql functions. In plpgsql, you can build up a query string and
use execute.
You may consider seeing whether or not there's another way to lay out
the data as well that might be easier to work with.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2006-11-25 23:00:50 | Re: Inserting values into a variable table |
Previous Message | Richard Broersma Jr | 2006-11-25 22:23:18 | Re: Inserting values into a variable table |