Displaying 1 result from an estimated 1 matches for "myview_insert".
2006 Sep 20
3
Can this 1337 PostgreSQL Subquery Union be done in AR?
Just wondering if it''s possible, without resorting to find_by_sql.
select id, title, datetime, type from (
select id, title, added as datetime, ''items'' as type from items
union
select id, headline as title, datetime, ''news'' as type from news
) as items order by datetime desc limit 50;
I''m also curious if it''s possible in MySQL.
Joe