R: Table as parameter

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-general(at)postgresql(dot)org, Alex Paulo <alexpaulooliveira(at)gmail(dot)com>
Subject: R: Table as parameter
Date: 2009-08-14 12:40:37
Message-ID: 402216.75943.qm@web24601.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I have a problem: I need put the "table name" as
> a parameter in a function!

I think you have to use dynamic statements:

http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-08-14 12:42:58 Re: Table as parameter
Previous Message Scara Maccai 2009-08-14 12:37:14 adding a nullable col could rewrite the whole table?