How building a dynamic query in a postgresql-function?
Posted on 2005-05-16
I would like to know how I've to build and execute a dynamic sql query in a postgresql-function.
More details :
I've 3 parameters :
* Customer Name
* Customer First Name
* Customer Account Number
some of those fields are filled in. The postgre-sql function receive the 3 parameters. In the function I want to create a select query with the filled-in values (not blank values).
I've noticed that the execute functions doesn't return any results.
Can you please send me a short example?
Thanks a lot!