How can I use a name of table in attribute of function, I try PREPARE ...

From: Benoît Bournon <benoit(dot)bournon(at)adelis(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How can I use a name of table in attribute of function, I try PREPARE ...
Date: 2003-05-27 11:53:57
Message-ID: 3ED351D5.3060408@adelis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I can do that on PostgreSQL 7.3 ??

Is it possible to do that ? or must I upgrade my server ??

PREPARE q1(text) FROM SELECT * FROM pg_tables WHERE tablename = $1 ;
EXECUTE q1 USING 'client' ;

DEALLOCATE q1 ;

Browse pgsql-sql by date

  From Date Subject
Next Message Benoît Bournon 2003-05-27 12:44:32 Upgrade 7.2.3 -> 7.3 or more
Previous Message Christoph Haller 2003-05-27 08:55:40 Re: Using UPPER and TRIM (INDEX usage)