NAME

DB::Object::ANY - ANY Operator Object

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)

DESCRIPTION

This is the ANY object class inheriting from DB::Object::Operator

METHODS

new

Takes a list of values that are saved in the newly created object returned.

as_string

Returns a string representation of this operator.

For example:

$dbh->ANY( qw( some other words ) );
# ANY ( some, other, words );

operator

Returns ANY

value

my @values = $op->value;
my $values = $op->value;

In list context, returns an array of those values passed to "new" and in scalar context, it returns those value as array reference.

OVERLOADING

Objects for this class have their == and != operators overloaded.

When overloading is called, it returns a new DB::Object::Expression that represents the formatted statement.

SEE ALSO

https://www.postgresql.org/docs/current/arrays.html#ARRAYS-SEARCHING

https://www.postgresql.org/docs/current/functions-comparisons.html#FUNCTIONS-COMPARISONS-IN-SCALAR

(There is no ANY operator in MySQL or SQLite)

AUTHOR

Jacques Deguest <jack@deguest.jp>

COPYRIGHT & LICENSE

Copyright (c) 2023-2026 DEGUEST Pte. Ltd.

You can use, copy, modify and redistribute this package and associated files under the same terms as Perl itself.