How can I use a name of table in attribute of function, I try PREPARE ... - Mailing list pgsql-sql

From Benoît Bournon
Subject How can I use a name of table in attribute of function, I try PREPARE ...
Date
Msg-id 3ED351D5.3060408@adelis.com
Whole thread Raw
List 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 ;




pgsql-sql by date:

Previous
From: "Morten Tryfoss"
Date:
Subject: Re: Index scan never executed?
Next
From: "Danny Su"
Date:
Subject: generic return for functions