Correct pg_type for a list of columns with SELECT?

Howdy, Thanks in advance for any guidance you may be able to provide. The following query throws error: could not determine data type of parameter $1 $1 contains a comma delimited list of column names. I can run the query on the CLI and it works. If I swap the question mark that is $1 in

Re: Correct pg_type for a list of columns with SELECT?

On 11/24/2013 10:05 AM, dome stuff wrote: $1 contains a comma delimited list of column names. I can run the query on the CLI and it works. If I swap the question mark that is $1 in the query, with a static column list, the query works in perl. Presumably I should be able to pass a column

Re: Correct pg_type for a list of columns with SELECT?

Thanks John, I was able to come up with something that works about the same (though a little clunky) by passing column names to the fetchall_arrayref function. Should someone search out this email in the future, the solution was to wildcard the SELECT statement and use the following feature as