you enormously. Lest you think I'm
> biased, I dba a mysql box professionally...every time I pop into the
> mysql shell I feel like I'm stepping backwards in time about 5 years.
> Don't let the inability to return multiple sets trip you up...you are
> missing the big
SELECTs.
I personally find the ability to do a direct SELECT from a stored
procedure to the client extremely useful (MySQL 5+). It makes data
retrieval easier to program than having a stored procedure return open
cursors or OUT parameters (saving additional SELECT queries after the
CALL() ).
Ok, e
QL is still relatively small and I
wanted to check my options before I dig myself too deeply into MySQL to
make a potential sensible migration too expensive :)
Maybe I'm going to revisit Postgresql again in 2009 or 2010 :)
Vladimir
--
Vladimir Dzhuvinov * www.valan.net * PGP key ID AC9A5C6C
signature.asc
Description: OpenPGP digital signature
result sets through pg_get_result(), but only for requests issued
asynchronously:
http://bg2.php.net/manual/en/function.pg-get-result.php
> Out of curiosity, what language are you using?
For MySQL I've been mostly using PHP, occasionally Java, Python and C.
Vladimir
--
Vladimir Dzhuvinov
x27;re still going to get a
result set, it's just going to be an empty one (result with no rows).
So, no matter how many rows the SELECT statements resolve to, you're
always going to get two result sets :)
Vladimir
--
Vladimir Dzhuvinov * www.valan.net * PGP key ID AC9A5C6C
signature.asc
Description: OpenPGP digital signature
ode, that
> allows multirecord sets.
Yes, I'll be glad to examine your patch. At least to get an idea of
what's involved in implementing multiple result sets.
Please, send the code or a link to it directly to my email (so as not to
spam the list ;)
Greetings from Bulgaria,
Vladimir
ansactions encapsulated within SPs, clients
allowed to do CALL only). Anyway, thanks everyone for the cursors tip :)
Vladimir
--
Vladimir Dzhuvinov * www.valan.net * PGP key ID AC9A5C6C
signature.asc
Description: OpenPGP digital signature
lt set (zero or more rows)
SELECT * FROM accounts WHERE account_holder = user_id;
END;
So, is it true that as of Postgresql 8.3 there is no way to have a
pgpqsql function return multiple SELECTs?
Vladimir Dzhuvinov
--
Vladimir Dzhuvinov * www.valan.net * PGP key ID AC9A5C6C
