NAME

IO::Async::Pg::Results - Query result wrapper

SYNOPSIS

my $result = await $conn->query('SELECT * FROM users');

# Access rows
for my $row (@{$result->rows}) {
    say $row->{name};
}

# First row
my $user = $result->first;

# Count
my $count_result = await $conn->query('SELECT COUNT(*) FROM users');
my $count = $count_result->scalar;

METHODS

rows

Returns arrayref of all rows as hashrefs.

first

Returns first row as hashref, or undef if empty.

count

Returns number of rows.

columns

Returns arrayref of column names.

scalar

Returns first column of first row. Useful for COUNT(*) queries.

is_empty

Returns true if result has no rows.

rows_affected

Returns number of rows affected by INSERT/UPDATE/DELETE.

AUTHOR

John Napiorkowski <jjn1056@yahoo.com>