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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly