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)
|
Список | 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 по дате отправления: