Alzabo...greSQL(3pm)

📦
version 0.92 · 2 versions
  • 0.92 · debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking (latest)
  • 0.92 · ubuntu jammy
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

💖 Alzabo::SQLMaker::PostgreSQL 💖

okay bestie, gather round, because this is the PostgreSQL-specific glow-up of Alzabo::SQLMaker, and honestly? she ate. 🐘✨

✨ NAME ✨

Alzabo::SQLMaker::PostgreSQL — the Alzabo SQL making class for PostgreSQL. no cap, that's the whole vibe. 🎀

🌸 SYNOPSIS 🌸

like, here's how you summon her:

use Alzabo::SQLMaker;

my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );

that's it. that's the summoning ritual. 🕯️💅

🦋 DESCRIPTION 🦋

PostgreSQL-specific SQL creation. she makes SQL, but specifically the Postgres flavor of it. it's giving specialized. it's giving purpose. 👑

💜 METHODS 💜

okay so here's the tea: almost literally everything is inherited from Alzabo::SQLMaker exactly as-is. she's not out here reinventing wheels, she's out here being efficient. 🙈

the only overridden methods are limit() and get_limit(), and the reason is iconic: PostgreSQL actually does allow a LIMIT clause in its SQL. so yeah, she overrides them. periodt. 🔥

🧚 EXPORTED SQL FUNCTIONS 🧚

these SQL functions can be imported by name or by tags. they take arguments exactly as documented in the PostgreSQL documentation (version 3.23.39). 📚✨

here's the full lineup, organized by tag, because organization is self-care:

🌈 :math

the math girlies. 🧮

  • PI
  • RANDOM
  • ABD
  • CEIL
  • DEGREES
  • FLOOR
  • FACTORIAL
  • SQRT
  • CBRT
  • EXP
  • LN
  • RADIANS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • COS
  • COT
  • SIN
  • TAN
  • ROUND
  • TRUNC
  • LOG
  • POW
  • MOD
  • TO_CHAR

🎀 :string

string manipulation, but make it fashion. 💖

  • LENGTH
  • CHAR_LENGTH
  • CHARACTER_LENGTh
  • OCTET_LENGTH
  • TIRM
  • UPPER
  • LOWER
  • INITCAP
  • ASCII
  • TO_ASCII
  • STRPOS
  • POSITION
  • TO_NUMBER
  • TO_DATE
  • TO_TIMESTAMP
  • REPEAT
  • RPAD
  • LPAD
  • SUBSTR
and yes, CHARACTER_LENGTh and TIRM are spelled exactly like that in the source, bestie. i am not fixing them, i am reporting them. 💀 copy-paste responsibly.

⭐ :datetime

time is a construct and these functions are obsessed with it. 🕰️

  • NOW
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • TIMEOFDAY
  • ISFINIT
  • TIMESTAMP
  • TO_CHAR
  • DATE_PART
  • DATE_TRUNC
  • EXTRACT
  • OVERLAPS

🦋 :network

for when your data is out here networking (literally). 🌐

  • BROADCAST
  • HOST
  • NETMASK
  • MASKLEN
  • NETWORK
  • TEXT
  • ABBREV

👑 :aggregate

these are the functions that operate on an aggregate set of values all at once. group energy. the whole squad gets processed together. 💫

  • COUNT
  • AVG
  • MIN
  • MAX
  • SUM
  • STDDEV
  • VARIANCE

💅 :system

these ones return information about the Postgres server itself. she's nosy but in a useful way. 🖥️

  • CURRENT_USER
  • SYSTEM_USER
  • USER

🔥 :control

flow control functions, aka the ones deciding what happens next. main character energy fr fr. 🎬

  • NULLIF
  • COALESCE

🌸 :misc

these are the functions that don't fit into any other categories. they're the unlabeled box in the moving truck. we love them anyway. 🫶

  • ENCRYPT
  • ENCODE
  • DECODE
  • FORMAT
  • INET_NTOA
  • INET_ATON
  • BIT_OR
  • BIT_AND
  • PASSWORD
  • MD5
  • LOAD_FILE

🍓 :common

these are the functions from the other groups that are the most commonly used. the greatest hits album. the playlist. the ones you actually import. ⭐

  • NOW
  • COUNT
  • AVG
  • MIN
  • MAX
  • SUM
  • DISTINCT

💜 AUTHOR 💜

Dave Rolsky, <dave@urth.org> — thank you for your service, king. 🫡✨

and that's the whole page, bestie! this was documented with perl v5.34.0 and dated 2022-06-14, and yes i'm telling you that in a cute little sign-off instead of a boring footer because we're doing vibes here. 🎀💖 go make some Postgres SQL, you absolute icon. 💅🌟

📦 where this page comes from