"Owens, Steve" <Steve(dot)Owens(at)usa(dot)xerox(dot)com> writes:
> EXEC SQL SELECT get_foo(1) INTO :record;
> I get a "ERROR: Cannot display record of type RECORD at line 26".
I know zip about ECPG, but I'd think a more likely bet is
EXEC SQL SELECT * INTO :record FROM get_foo(1);
or
EXEC SQL SELECT * FROM get_foo(1) INTO :record;
depending on what your theology is about the placement of INTO. The
point is that a function returning setof-record is a table source and
should appear in FROM.
regards, tom lane