"Owens, Steve" <Steve.Owens@usa.xerox.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);
orEXEC 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