Re: Error: rows returned by function are not all of the same row type

2019-07-09 Thread Andrey Sychev
> Please do not top post on the Postgres lists. Thank you for the advice. I will take into account this rule in the future. > See contrib/tablefunc/tablefunc.c crosstab_hash() as an example. Thank you. I hope this will be good starting point for me. -- Best regards, Andrey

Re: Error: rows returned by function are not all of the same row type

2019-07-05 Thread Andrey Sychev
as "RETURNS SETOF". Does definition of the function need to be changed if I rewrite code to return tuplestore? > Andrey Sychev writes: >> I have written C-language function that returns >> multiple composite rows. >> Generally function works as expected, bu

Error: rows returned by function are not all of the same row type

2019-07-04 Thread Andrey Sychev
{ SPI_freetuptable(table); } ereport(NOTICE, (errmsg("P6: [%s]-(%d)", (const char*)__FUNCTION__, max_calls))); ret = SPI_exec("DROP TABLE results", 0); if(ret != SPI_OK_UTILITY) { elog(ERROR, "spi_match: SPI_exec (20) returned %d", ret); } SPI_finish(); SRF_RETURN_DONE(funcctx); } PG_RETURN_VOID(); } -- Best regards, Andrey Sychev andrey.syc...@cifrasoft.com