DB::Object::ALL - ALL Operator Object
my $op = $dbh->ALL( 1, 2, 3 ); # will produce: ALL ( 1, 2, 3 ) "'something'" == $dbh->ALL( qw( some other words ) ); # 'something' ALL ( some, other, words ); "something" != $dbh->ALL( qw( some other words ) ); # 'something' NOT ALL ( 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->ALL( $sth ); say $sql; # t.somefield ALL (SELECT DISTINCT t.field FROM my_table t)
This is the ALL object class inheriting from DB::Object::Operator
ALL
Takes a list of values that are saved in the newly created object returned.
Returns a string representation of this operator.
For example:
$dbh->ALL( qw( some other words ) ); # ALL ( some, other, words );
Returns ALL
In list context, returns an array of those values passed to "new" and in scalar context, it returns those value as array reference.
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.
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 ALL operator in MySQL or SQLite)
Jacques Deguest <jack@deguest.jp>
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.
To install DB::Object, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DB::Object
CPAN shell
perl -MCPAN -e shell install DB::Object
For more information on module installation, please visit the detailed CPAN module installation guide.