Обсуждение: execute dynamic strings
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.
Stefan...... > 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 > I know I must use execute and prepare syntax, but I don't know how to > create the function. Is this a postgreSQL function you've written or are you planning on using an external language like perl or php? It would be helpful if you posted a code snippet that you've tried. brew ========================================================================== Strange Brew (brew@theMode.com) Check out my Stock Option Covered Call website http://www.callpix.com and my Musician's Online Database Exchange http://www.TheMode.com ==========================================================================