[Haskell-cafe] Announce: HDBI-1.3 and friends
gauthier.segay at gmail.com
Wed Oct 16 15:56:30 UTC 2013
I got it Alexey, thanks.
I wasn't aware that this feature is not widespread in RDBMS, indeed
postgresql and sqlite are not exposing it; so this would require some
added complexity in those drivers without added benefits since it
would be equivalent to sending separate statements.
On Wed, Oct 16, 2013 at 5:50 PM, Alexey Uimanov <s9gf4ult at gmail.com> wrote:
> Now I understand what you want, but it looks like something strange. Why
> dont just execute many statements and accumulate them in some container and
> after that fetch results of this statements ? For me It looks like something
> foreign in HDBI especially because I did not see any support of such things
> in native database interfaces not in Postgresql nor in SQlite.
> 2013/10/16 Gauthier Segay <gauthier.segay at gmail.com>
>> no the use case is to issue a bunch of disparate select statements,
>> i.e. retrieving data from several tables in a single roundtrip.
>> select 1,2,3
>> select 'a', 'b'
>> In this case, I'd like to call the API in this manner (or something
>> -- statement is prepared
>> rows1 <- fetchAllRows statement
>> _ <- nextResults statement
>> rows2 <- fetchAllRows statement
>> -- continue
>> right now, with hdbc-odbc (nextResults doesn't exist though so I don't
>> call it) rows2 will be an empty list, I'd expect it to be[(SqlText
>> "a"), (SqlText "b")]
>> I assume in the case of odbc, the related C function is SQLMoreResults
> Haskell-Cafe mailing list
> Haskell-Cafe at haskell.org
More information about the Haskell-Cafe