sql union operator support ? about sqlpp11 HOT 6 CLOSED

Not yet.

It is on my TODO list, but not top priority from my personal
perspective. Should not be too hard, though. Patches are welcome, of
course :-)

Best,

Roland

from sqlpp11.

any ideas how to implement ? - I'm newbie to the lib :)

from sqlpp11.

It depends on whether union should be a member function of select or a
free function. Not sure yet.

In the first case:
Take a look at the select statement. The first step would be to add
another component that allows calling a "union_" function.

In the second case:
Create a free function, that takes two or more select statements and
returns a statement that contains these selects plus the ability to call
order and limit.

I am leaning towards the free function at the moment, but I have not
really thought it through.

from sqlpp11.

Actually, I think we should have both, member function and free
function, both yielding a union_t, which again can be combined with
other unions or selects by calling the union_ member or free function.

from sqlpp11.

Hi,

Finally, I got to looking into unions: I just pushed a first version of union_ member function. It has almost no compile-time checks included yet. These will follow in the next few days.

Cheers,

Roland

from sqlpp11.

UNION support is now included in releases > 0.30

Please use tests/UnionTest as guideline for the time being. Documentation will follow step by step...

from sqlpp11.