Search Postgresql Archives

FW: execute dynamic strings. need help.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux