Ah, yes, I forgot about H2's array notation, thanks for that hint. Would it be difficult to extend H2 in a way that it would coerce tuples into arrays or arrays into tuples for these cases? This would probably help improve SQL standard conformance and compatibility with other dialects. I think the tuple use-case is more popular than the array use-case
What do you think? Am Freitag, 31. August 2012 18:05:54 UTC+2 schrieb Thomas Mueller: > > Hi, > > For H2, the expression (1, 2) is an array, so the queries would need to be: > > select 1 from dual where (1, 2) in (select (1, 2) from dual); > select 1 where (1, 2) in (select (1, 2)); > select 1 from dual where (1, 2) in ((1, 2)); > > Regards, > Thomas > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/LJEG226OFoUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
