[SQL] Returning Setof Record Dynamically

Hi,   I am attempting to use Setof Record dynamically. I am developing an application where I will not know what the end-user is trying to work with from a web front end. Thus I will not know before hand the structure of the table I am trying to pull the record from.   My Code:   CREATE FUNCTION re

[SQL] Use of Setof Record Dynamically

Hi,   I am attempting to use Setof Record dynamically. I am developing an application where I will not know what the end-user is trying to work with from a web front end. Thus I will not know before hand the structure of the table I am trying to pull the record from.   My Code:   CREATE FUNCTION r

[SQL] REPOST[GENERAL] Quoting for a Select Into - Please Help

Hi,   Could someone help me with quoting this right?   select into aliasvalue ''|| trim(arrayval[i]) ||''  from ''|| trim(realname) ||'' where ''|| trim(searchfield) ||'' like %''|| trim(searchvalue) ||''%;   The parser does not seem to want to put the value of the variables into the