Jason Thaxter (th...@gomoos.org)

Any suggestions on how to use the overlaps operator? Using Postgresql..

I read the SQL::Abstract page after bottoming out on:
Cannot mix placeholder styles ":foo" and "?"

I found this in the docs:

    my %where  = (
        user   => 'nwiger',
        completion_date => {
           -not_between => ['2002-10-01', '2003-02-06']
        }
    );

    Would give you:

    WHERE user = ? AND completion_date NOT BETWEEN ( ? AND ? )


But it doesn't seem to recognize OVERLAPS the same way as BETWEEN:

    (start_time,end_time)" => { -overlaps => [$pg_alpha, $pg_omega] }

generates:

    WHERE ( ( ( (start_time,end_time) OVERLAPS $1 ) OR ( ...

Of course what I want is
    WHERE ( ( ( ( start_time,end_time) OVERLAPS (?, ?)

I could simulate overlaps with some OR clauses, but I made a mistake with that
before, so I'd rather use the proper SQL function.

That cookbook example is cool.

I have two databases for two applications. One takes the schema from the
first, then uses table inheritance to add some columns. I'd like to inherit
everything, into a full second set of proxy classes, e.g. App2::Schema
inherits from App1::Schema, then just add extra ->add_column bits for my
extra inherited table.

I thought that the reliance on __PACKAGE__ should make this a snap, but I'm
having some issues. I'm going to start by checking out the cookbook example
and seeing where I differ from it.

Any tips on this - ? Methods in particular I'd need to override? new?
inflate_result?