I can't get row type from tuple (SPI)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема I can't get row type from tuple (SPI)
Дата
Msg-id BAY20-F5EA78637DC0E29C45E7F0F9630@phx.gbl
обсуждение исходный текст
Ответы Re: I can't get row type from tuple (SPI)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello

I execute "select anyrowfce(..)" in plpgsql via exec_run_select

I need to get inner row, but I can't find good way for it

retval = SPI_getbinval(estate->eval_tuptable->vals[0], estate->eval_tuptable->tupdesc,1);

rettype = SPI_gettypeid(estate->eval_tuptable->tupdesc,1);
rettupdesc = lookup_rowtype_tupdesc(rettype,0);

rettupdesc is ok, but when I try SPI_getbinval(retval, rettupdesc, ...) I 
kill backend.

What I do wrong? What is optimal process to get first field in row, when 
this first field is row too.

for example I need to way for value 1 in select

select row(row(1,2,3)); => "("(1,2,3)")"

Can I get inner tupdesc without lookup_rowtype_tupdesc?

Thank you very much

Pavel Stehule

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/



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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: [ANNOUNCE] PostgreSQL 8.1 RC1
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: pgInstaller 8.1 built