Re: Using a variable as tablename ins plpgsql?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using a variable as tablename ins plpgsql?
Date: 2008-10-20 16:51:33
Message-ID: 162867790810200951r59512c0dv807a045c84a7f2b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

2008/10/20 Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>:
> Hi people,
>
> Hopefully this is a quickie, I want to pass in a table name to a plpgsql function and then use that table name in my queries.
>
> Is EXECUTE the only way to do this?
>
> Ta
> Glyn
>

yes,

regards
Pavel Stehule

>
>
>
>
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Moreno 2008-10-20 16:54:53 Re: Using a variable as tablename ins plpgsql?
Previous Message Glyn Astill 2008-10-20 16:45:04 Using a variable as tablename ins plpgsql?