Re: Function returns composite type
От | Teodor Sigaev |
---|---|
Тема | Re: Function returns composite type |
Дата | |
Msg-id | 3EE6E705.9020001@sigaev.ru обсуждение исходный текст |
Ответ на | Re: Function returns composite type (Joe Conway <mail@joeconway.com>) |
Ответы |
Re: Function returns composite type
|
Список | pgsql-hackers |
> >> 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. it's a great pity :(. But in function I already make TupleDesc: tupdesc = CreateTemplateTupleDesc(attnum, false); for (i = 0; i <attnum; i++) { sprintf(attname, "z%d", i+1); TupleDescInitEntry(tupdesc, i+1, attname, INT4OID,-1, 0, false); } As I understand, this code makes full description of returning value, including types and column's names. Is this info used anywhere? -- Teodor Sigaev E-mail: teodor@sigaev.ru
В списке pgsql-hackers по дате отправления: