Re: Function returns composite type

Teodor Sigaev wrote:
> Ok, RECORD was a keyword, thank you. But I have questions:
> 1 What do you mean SRF? Set Return Function?

It refers to functions returning one or more tuples. From a practical 
standpoint, it is a function that is (and must be) used in the FROM 
clause like a table (hence also known as a "table function").
> # select * from qqn(1,2) as c(qq int4, qq1 int4);>  qq | qq1> ----+----->   1 |   2> (1 row)>
> It works fine. But is there way not to point 'as c(qq int4, qq1 int4)'? 

If you mean, is there a way to leave out the 'as c(qq int4, qq1 int4)', 
the answer is no. You need to either declare the function to return a 
determinate data type, or you have to specify the data type at runtime 
in the query string.

Joe