—

              
HideShow 77 lines of Pod
=encoding utf-8
=head1 NAME
DB::Object::ANY - ANY Operator Object
=head1 SYNOPSIS
    my $op = $dbh->ANY( 1, 2, 3 );
    # will produce:
    ANY ( 1, 2, 3 )
    "'something'" == $dbh->ANY( qw( some other words ) );
    # 'something' ANY ( some, other, words );
    "something" != $dbh->ANY( qw( some other words ) );
    # 'something' NOT ANY ( some, other, words );
    my $tbl = $dbh->my_table || die( $dbh->error );
    $tbl->as( 't' );
    my $sth = $tbl->select( 'DISTINCT field' );
    my $sql = $tbl->fo->somefield == $dbh->ANY( $sth );
    say $sql;
    # t.somefield ANY (SELECT DISTINCT t.field FROM my_table t)
=head1 DESCRIPTION
This is the C<ANY> object class inheriting from L<DB::Object::Operator>
=head1 METHODS
=head2 new
Takes a list of values that are saved in the newly created object returned.
=head2 as_string
Returns a string representation of this operator.
For example:
    $dbh->ANY( qw( some other words ) );
    # ANY ( some, other, words );
=head2 operator
Returns C<ANY>
=head2 value
In list context, returns an array of those values passed to L</new> and in scalar context, it returns those value as array reference.
=head1 OVERLOADING
Objects for this class have their C<==> and C<!=> operators overloaded.
When overloading is called, it returns a new L<DB::Object::Expression> that represents the formatted statement.
=head1 SEE ALSO
L<https://www.postgresql.org/docs/current/arrays.html#ARRAYS-SEARCHING>
L<https://www.postgresql.org/docs/current/functions-comparisons.html#FUNCTIONS-COMPARISONS-IN-SCALAR>
(There is no C<ANY> operator in MySQL or SQLite)
=head1 AUTHOR
Jacques Deguest E<lt>F<jack@deguest.jp>E<gt>
=head1 COPYRIGHT & LICENSE
Copyright (c) 2023 DEGUEST Pte. Ltd.
You can use, copy, modify and redistribute this package and associated
files under the same terms as Perl itself.
=cut