I’m wrighting a stored function and I need to have table-variable like in MSSQL. I need to have possibility to insert/read/delete records from this table and use it in queries.
Temp tebles are not suitable for me, because if I run this function simultaneously several times – same temp teble will be used in all calls and i’ll recieve totally mess there. Wrap the body of function in transaction is not an option for me – it will block another users.
So what can I use instead ?