Hi,
I'm looking at using Rose::DB::Object::QueryBuilder on its own (without
the rest of RDBO) to generate some SQL. It looks like this should work
fine. However, I'm finding the in_set and in_array methods very confusing.
According to the docs, 'COLUMN' => { in_set => 'A' } generates the SQL
"A IN COLUMN". This seems like the reverse of normal usage, e.g. "name
IN ('john','paul')". Can anyone explain what this might be used for?
Also, what is the difference between "IN" (in_set) and "= ANY"
(in_array)? According to all the database docs I've seen, these are
equivalent.
Were these meant to be used for subqueries? I do intend to work with
subqueries and am thinking about how to incorporate them or else cheat
with some post-processing.
- Perrin
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
