On Fri, Nov 30, 2018 at 3:26 PM Simon Walter <si...@gikaku.com> wrote:
> On 11/30/2018 11:20 PM, Dominique Devienne wrote: > To be honest, I am using apr_dbd as I would like to support more than > just SQLite. So I will need to play around with MySQL and PostgreSQL at > least and maybe branch if SQLite is in use. I have no idea yet if MySQL > and/or PostgreSQL can handle this scenario and how they do it. > PostgreSQL has native array support. Also has JSON support. So I'm fairly sure both a possible with PG, except with different syntaxes of course. Don't know about MySQL. Oracle has a VARRAY datatype, and you use the TABLE() operator to turn its content into a table-values "thing", so you can write WHERE c in (TABLE(:1)) and bind the VARRAY, which you've built-up "client-side". BTW, the fact there's no "client-side" with SQLite is typically used as an argument for not supporting "natively" binding the RHS of the WHERE IN clause, and that the work-arounds are good enough. Obviously I disagree :). --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
