Mojo::Pg::Results(3)

💖 Mojo::Pg::Results — bestie, it's literally the results container 💖

okay so you know how this page is Mojo::Pg::Results(3) from the User Contributed Perl Documentation? yeah. that's her. that's the one. let's go 🫶

---

✨ NAME ✨

Mojo::Pg::Results — Results. that's it. that's the name. she's a container, she contains. periodt 💅

---

🌸 SYNOPSIS 🌸

use Mojo::Pg::Results;

my $results = Mojo::Pg::Results->new(sth => $sth);
$results->hashes->map(sub { $_->{foo} })->shuffle->join("\n")->say;

look at that chain. map, shuffle, join, say. it's giving main character energy and honestly? ate 🔥

---

🦋 DESCRIPTION 🦋

okay so real talk: Mojo::Pg::Results is a container for DBD::Pg statement handles that get used by Mojo::Pg::Database. like, that's the whole gig. she holds the thing. the thing gets held. iconic behavior honestly ✨

---

🎀 ATTRIBUTES 🎀

Mojo::Pg::Results implements the following attributes. yes, both of them. we stan a concise queen 👑

💜 db

my $db   = $results->db;
$results = $results->db(Mojo::Pg::Database->new);

this is the Mojo::Pg::Database object that these results belong to. like, whose results are these?? hers. they're hers. 💖

💜 sth

my $sth  = $results->sth;
$results = $results->sth($sth);

the DBD::Pg statement handle that the results get fetched from. the source of truth. the origin story. the lore 🌈

---

👑 METHODS 👑

Mojo::Pg::Results inherits all methods from Mojo::Base and implements the following new ones. so you get the base ones for free, no cap 🧚

🍓 array

my $array = $results->array;

fetch one row from sth and hand it back as an array reference. one (1) row. singular. don't be greedy bestie 💀

🍓 arrays

my $collection = $results->arrays;

fetch all rows from sth and return them as a Mojo::Collection object stuffed with array references. the whole buffet. 🍽️

# Process all rows at once
say $results->arrays->reduce(sub { $a + $b->[3] }, 0);

🍓 columns

my $columns = $results->columns;

returns the column names as an array reference. just the names. the labels. the vibes 🏷️

# Names of all columns
say for @{$results->columns};

🍓 expand

$results = $results->expand;

this one decodes json and jsonb fields automatically to Perl values for all rows. no manual decoding, no suffering, we love to see it 🙈

# Expand JSON
$results->expand->hashes->map(sub { $_->{foo}{bar} })->join("\n")->say;

🍓 finish

$results->finish;

indicates that you are finished with sth and you will not be fetching all the remaining rows. like, you're done. you said what you said. close the door behind you 🚪

🍓 hash

my $hash = $results->hash;

fetch one row from sth and return it as a hash reference. one row again. the named version this time ✨

🍓 hashes

my $collection = $results->hashes;

fetch all rows from sth and return them as a Mojo::Collection object full of hash references. all of them. every single one. obsessed 💖

# Process all rows at once
say $results->hashes->reduce(sub { $a + $b->{money} }, 0);

🍓 new

my $results = Mojo::Pg::Results->new;
my $results = Mojo::Pg::Results->new(sth => $sth);
my $results = Mojo::Pg::Results->new({sth => $sth});

constructs a brand new Mojo::Pg::Results object. three ways to do it, pick your fighter, all of them slay 🌟

🍓 rows

my $num = $results->rows;

the number of rows. that's the whole method. short king 👑

🍓 text

my $text = $results->text;

fetch all rows from sth and turn them into a table using tablify in Mojo::Util. pretty little table. aesthetics ✨

---

🌈 SEE ALSO 🌈

• Mojo::Pg
• Mojolicious::Guides
• <https://mojolicious.org>

---

and that's the whole page bestie 💅 this was Mojo::Pg::Results(3), perl v5.42.0, dated 2026-01-17. go forth and fetch your rows responsibly. mwah 🫶💖✨