Re: [GENERAL] Function Returning SETOF RECORD: Trouble With Char Type

2008-03-20 Thread Angus B. Atkins-Trimnell
Thanks a lot. I missed your post when it first came up, but I just tried double-quoting the type indicator and it worked like a charm! --Angus Tom Lane wrote: Angus B. Atkins-Trimnell [EMAIL PROTECTED] writes: I am having trouble with a function designed to return all column constraints

[GENERAL] Function Returning SETOF RECORD: Trouble With Char Type

2008-03-12 Thread Angus B. Atkins-Trimnell
Hello, I am having trouble with a function designed to return all column constraints on a table. The problem is not in the SQL, which works fine on its own. The problem comes when the function is invoked using SELECT * FROM function_name(arg_name) AS temp_table(.). When the function

Re: [GENERAL] Function Returning SETOF RECORD: Trouble With Char Type

2008-03-12 Thread Tom Lane
Angus B. Atkins-Trimnell [EMAIL PROTECTED] writes: I am having trouble with a function designed to return all column constraints on a table. I think the problem is that you're declaring the contype return column as char (ie, character(1)) when pg_constraint.contype is actually char (a