SRF question

Поиск
Список
Период
Сортировка
От Franco Bruno Borghesi
Тема SRF question
Дата
Msg-id 1063030898.6309.1.camel@taz.oficina
обсуждение исходный текст
Ответы Re: SRF question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi everyone.

I need to create a C function that returns a row, and the type of this row must be the same of a type that I've created using CREATE TYPE.

I've seen the function:
TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases)
but I don't understand two things:

1)I just know the name of the type, not its oid... woud it be ok if I execute a SELECT on pg_type asking for typname to find the oid of the type I want to return? or is there any function like RelationNameGetTupleDesc (maybe TypeNameGetTupleDesc) that I can call passing just the typename as a char *?

2)in case TypeGetTupleDesc is the only option, what is the second argument?

Thanks in advance.

PS: sorry if you receive this message twice, I sent it on saturday but it seems it never arrived :)

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: plPGSQL bug in function creation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] plPGSQL bug in function creation