Hi,
First of all, let me say that I've become a huge fan of this gem. Sequel is
probably top-5 in the ruby world, and one could argue it is the only really
"professional" gem of the bunch.
I've been tasked with "translating" the queries in use on some obscure
projects to plain ruby (or plain sequel). Some of these are quite
complicated and I don't necessarily have the knowledge to rewrite them in a
more convenient way, for which I just want to blatantly translate them to
sequel-speak.
One of them is quite complicated, though. I'll show you the complicated
part:
select cfs."all-ip_cfs_instance_id" as line,
...
from
...
table(cast(multiset
(select table.column1,
....,
) as
tableof10strings))(+) warp
where ...
I've omitted the unimportant or easy-to-translate parts. Bottom line, I
have an inner sub-query in the "From" clause being transformed by applying
"multiset", "cast" and "table" and with some spooky sintax (the "(+)").
I've seen that Sequel supports "cast", but not for sub-queries, and I
couldn't apply the remaining methods. How could I solve this one?
Many thx in advance for the input,
Tiago
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
