vince maxey <vamax27@yahoo.com> writes:
> I am running my test procs from the pgAdminIII GUI. Is my syntax wrong to
> execute the function? If I run select test_proc1(3), I do get the correct
> result which is a column header (test_proc1 integer) and a value (2). So why
> wouldn't I get a 6-column result set when running select test_proc(2) ?
Because those functions return the name of a cursor, not the result of
fetching from the cursor. The same would have been true in any prior
release too, so I'm not sure why you're having trouble with 9.0 and
not before. You sure you haven't dropped a level of indirect fetch
from your client code?
regards, tom lane