FW: execute dynamic strings. need help.

From: Stefan(dot)Ardeleanu(at)siveco(dot)ro
To: pgsql-general(at)postgresql(dot)org
Subject: FW: execute dynamic strings. need help.
Date: 2005-02-22 15:06:27
Message-ID: E383500F7C4E70448157685481BF824801A9E846@internets3.main.siveco.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a function with 3 parameters (select clause, where clause and order
by clause (last two are optionally clauses). This clauses apply to a given
table. For example, the table table1

and the function table1_rwc (read by where clause).
Given, let's say, the followings values select_clause = '*', where_clause
'id = 1' and the order_by clause = 'id', it will be generate the result set
of the following query:

select * from Table1 where id = 1 order by id

I know I must use execute and prepare syntax, but I don't know how to create
the function.
Can you help me, please.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-02-22 15:23:39 Re: migration
Previous Message Bruno Wolff III 2005-02-22 14:57:22 Re: Is there a way to implicitly grant privileges to an implicitly created sequence?