function returning a row

Поиск
Список
Период
Сортировка
От Kjetil Haaland
Тема function returning a row
Дата
Msg-id 200411181454.31761.kjetil.haaland@student.uib.no
обсуждение исходный текст
Ответы Re: function returning a row  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
Hello

I have made my own type alignres that holds a string and an integer. I have
created the type in postgres and tried to insert into it and it works. I also
have a function that returns a row (or composite type). I have used

tupdesc = RelationNameGetTupleDesc("alignres");

to set it to return my own type.  When i try to use the function in postgres
it says

ERROR:  relation "alignres" does not exist

If i try to let the function use a type that is only created in postgres (not
c code) then it works.

Is it possible to use my own type to be returned?

-Kjetil

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

Предыдущее
От: Aarni Ruuhimäki
Дата:
Сообщение: Re: Querying a list of values
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: function returning a row