Multiple result sets
| От | Clodoaldo |
|---|---|
| Тема | Multiple result sets |
| Дата | |
| Msg-id | a595de7a0806011144n36c59e48n92384ff707b4b54@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Multiple result sets
Re: Multiple result sets |
| Список | pgsql-general |
I need that 5 queries, fired from the same ajax request to a web python application, see the same database snapshot. The driver is psycopg2. Since postgresql 8.2 functions can't return multiple result sets what would be the best aproach? All 5 queries return 2 columns but they are different types in each query. I could just do a union casting everything to text, adding one column identifying each query and then recast when receiving the result set. But that could be costly (i guess the union is) and not elegant at all. Those queries will fill select boxes and the ajax refresh should be very fast. Regards, Clodoaldo Pinto Neto
В списке pgsql-general по дате отправления: