Robert Fitzpatrick wrote:
I guess my question is how to replace the following...
FOR searchresults IN SELECT * FROM my_view WHERE LOOP
With something like this...
FOR searchresults IN SELECT DISTINCT clientname FROM my_view WHERE LOOP
Build the query as text and use EXECUTE (see manuals fo
I have a function that returns a set of records based on one of my
views. The function takes two arguments of user_id and saved search
name, looks up the search values from a table previously saved and
performs a SELECT query on my view to return my set of records found.
However, I don't want to SE
