SQL::R...greSQL(3pm)

πŸ“¦
version 0.8 Β· 4 versions
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

πŸ’– SQL::ReservedWords::PostgreSQL πŸ’–

okay bestie, welcome to the User Contributed Perl Documentation section, and this lil gem is called SQL::ReservedWords::PostgreSQL β€” that truncated SQL::R...greSQL(3pm) thing in the corner? that's just the page name being dramatic, it's giving abbreviation energy πŸ’…


✨ NAME ✨

SQL::ReservedWords::PostgreSQL β€” Reserved SQL words by PostgreSQL 🐘✨


🌸 SYNOPSIS 🌸

like, here's the whole vibe in one little snippet:

if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) {
    print "$word is a reserved PostgreSQL word!";
}

literally that's it. that's the whole flex 🫢


πŸ¦‹ DESCRIPTION πŸ¦‹

so what does this actually do? it determines if words are reserved by PostgreSQL. that's the entire mission statement, no cap. you hand it a word, it tells you whether Postgres has already claimed it. main character energy for your SQL parser πŸ’œ


πŸ‘‘ METHODS πŸ‘‘

πŸŽ€ is_reserved( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1. all four, bestie. it checks the whole squad 🌈

πŸŽ€ is_reserved_by_postgresql7( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3 or 7.4. just the 7.x girlies ✨

πŸŽ€ is_reserved_by_postgresql8( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 8.0 or 8.1. 8.x only, periodt πŸ’…

πŸŽ€ reserved_by( $word )

Returns a list with PostgreSQL versions that reserves $word. so instead of a yes/no you get the receipts β€” every version that's claiming that word πŸ“‹βœ¨

πŸŽ€ words

Returns a list with all reserved words. the whole roster. the full lineup πŸ”₯


πŸ’€ EXPORTS πŸ’€

Nothing by default. nothing. zero. nada. you gotta ask nicely πŸ™ˆ

Following subroutines can be exported:

  • is_reserved
  • is_reserved_by_postgresql7
  • is_reserved_by_postgresql8
  • reserved_by
  • words

that's the whole menu, pick your faves πŸ“


πŸ” SEE ALSO πŸ”


🌟 AUTHOR 🌟

Christian Hansen chansen@cpan.org β€” absolute icon, we stan πŸ‘‘


This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. free as in go wild, bestie πŸ’–


ok that's the whole page, tysm for reading, mwah πŸ’‹

signing off β€” this was SQL::ReservedWords::PostgreSQL from perl v5.34.0, dated 2022-06-17 πŸŽ€βœ¨πŸ¦‹

πŸ“¦ where this page comes from