Weave Code
Code Weaver
Helps Laravel developers discover, compare, and choose open-source packages. See popularity, security, maintainers, and scores at a glance to make better decisions.
Feedback
Share your thoughts, report bugs, or suggest improvements.
Subject
Message
Log in Register
Home
Packages
Postgresql For Doctrine
Docs

Postgresql For Doctrine Laravel Package

martin-georgiev/postgresql-for-doctrine

Adds PostgreSQL-specific power to Doctrine DBAL/ORM: rich native types (jsonb, arrays, ranges, network, geometric, etc.) plus DQL functions/operators for JSON and array querying. Supports PostgreSQL 9.4+ and PHP 8.2+.

View on GitHub
Deep Wiki
Context7

Mathematical Functions

This document covers PostgreSQL mathematical functions available in this library.

📖 See also: Common Use Cases and Examples for practical mathematical function examples

Trigonometric Functions

Radian-based functions

PostgreSQL function Register for DQL as Implemented by
sin SIN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sin
cos COS MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cos
tan TAN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Tan
cot COT MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cot
asin ASIN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Asin
acos ACOS MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Acos
atan ATAN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Atan
atan2 ATAN2 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Atan2
sinh SINH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sinh
cosh COSH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cosh
tanh TANH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Tanh
asinh ASINH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Asinh
acosh ACOSH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Acosh
atanh ATANH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Atanh

Degree-based functions

PostgreSQL function Register for DQL as Implemented by
sind SIND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sind
cosd COSD MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cosd
tand TAND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Tand
cotd COTD MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cotd
asind ASIND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Asind
acosd ACOSD MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Acosd
atand ATAND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Atand
atan2d ATAN2D MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Atan2d

Mathematical Functions

PostgreSQL functions Register for DQL as Implemented by
cbrt CBRT MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cbrt
ceil CEIL MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Ceil
degrees DEGREES MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Degrees
div DIV MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Div
erf ERF MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Erf
erfc ERFC MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Erfc
exp EXP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Exp
factorial FACTORIAL MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Factorial
floor FLOOR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Floor
gamma GAMMA MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Gamma
gcd GCD MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Gcd
generate_series GENERATE_NUMERIC_SERIES MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\GenerateNumericSeries
greatest GREATEST MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Greatest
lcm LCM MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Lcm
least LEAST MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Least
lgamma LGAMMA MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Lgamma
ln LN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Ln
log LOG MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Log
min_scale MIN_SCALE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\MinScale
pi PI MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Pi
power POWER MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Power
radians RADIANS MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Radians
random RANDOM MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Random
random_normal RANDOM_NORMAL MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\RandomNormal
round ROUND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Round
scale SCALE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Scale
sign SIGN MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sign
trim_scale TRIM_SCALE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\TrimScale
trunc TRUNC MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Trunc
width_bucket WIDTH_BUCKET MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\WidthBucket

Type Conversion and Formatting Functions

PostgreSQL functions Register for DQL as Implemented by
cast CAST MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Cast
to_char TO_CHAR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\ToChar
to_number TO_NUMBER MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\ToNumber

Note: TO_NUMBER supports Roman numeral conversion via the RN pattern (PostgreSQL 18+).

Hashing & Cryptographic Functions

PostgreSQL functions Register for DQL as Implemented by
md5 MD5 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Md5
sha224 SHA224 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sha224
sha256 SHA256 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sha256
sha384 SHA384 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sha384
sha512 SHA512 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Sha512

Bitwise and Boolean Aggregate Functions

PostgreSQL functions Register for DQL as Implemented by
bit_and BIT_AND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BitAnd
bit_or BIT_OR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BitOr
bit_xor BIT_XOR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BitXor
bool_and BOOL_AND MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BoolAnd
bool_or BOOL_OR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BoolOr
every EVERY MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Every

Statistical Aggregate Functions

PostgreSQL functions Register for DQL as Implemented by
corr CORR MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Corr
covar_pop COVAR_POP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\CovarPop
covar_samp COVAR_SAMP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\CovarSamp
stddev STDDEV MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Stddev
stddev_pop STDDEV_POP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\StddevPop
var_pop VAR_POP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\VarPop
variance VARIANCE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Variance

Utility and Miscellaneous Functions

PostgreSQL functions Register for DQL as Implemented by
any_value ANY_VALUE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\AnyValue
crc32 CRC32 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Crc32
crc32c CRC32C MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Crc32c
reverse (bytea) REVERSE_BYTES MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\ReverseBytes
row ROW MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Row
row_to_json ROW_TO_JSON MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\RowToJson
uuid_extract_timestamp UUID_EXTRACT_TIMESTAMP MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\UuidExtractTimestamp
uuid_extract_version UUID_EXTRACT_VERSION MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\UuidExtractVersion
uuidv4 UUIDV4 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Uuidv4
uuidv7 UUIDV7 MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\Uuidv7
xmlagg XML_AGG MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\XmlAgg

Usage Examples

-- WIDTH_BUCKET: bucket number (1-based) for a value in a histogram with N equal-width buckets
SELECT WIDTH_BUCKET(e.score, 0, 100, 10) as bucket, COUNT(*) as count
FROM Entity e GROUP BY bucket ORDER BY bucket

-- POWER used for square root and Pythagorean distance (no SQRT() in DQL)
SELECT POWER(e.value, 0.5) as square_root FROM Entity e WHERE e.value > 0
SELECT POWER(POWER(e.x2 - e.x1, 2) + POWER(e.y2 - e.y1, 2), 0.5) as distance FROM Entity e

-- Random reservoir sampling: WHERE filters ~10% of rows, ORDER BY shuffles them
SELECT e FROM Entity e WHERE RANDOM() < 0.1 ORDER BY RANDOM() LIMIT 100

-- GREATEST/LEAST with aggregates — clamp aggregate results to a floor or ceiling
SELECT e.category,
       GREATEST(MAX(e.value), 0) as max_non_negative,
       LEAST(MIN(e.value), 100) as min_capped
FROM Entity e GROUP BY e.category

📝 Function Categories:

Mathematical Functions

  • Basic Math: CEIL, FLOOR, ROUND, TRUNC for rounding operations
  • Power Functions: POWER, CBRT, EXP for exponential calculations
  • Logarithmic: LN, LOG for logarithmic operations
  • Trigonometric: DEGREES, RADIANS for angle conversions
  • Comparison: GREATEST, LEAST for finding extremes
  • Utility: SIGN, RANDOM, PI for various mathematical needs

💡 Tips for Usage:

  1. Mathematical functions work with numeric types and return appropriate precision
  2. WIDTH_BUCKET is excellent for creating histograms and analytics
  3. RANDOM() generates values between 0 and 1
  4. GREATEST/LEAST can take multiple arguments and handle NULL values
  5. Logarithmic functions require positive input values
Weaver

How can I help you explore Laravel packages today?

Conversation history is not saved when not logged in.
Prompt
Add packages to context
No packages found.
bugban/symfony
beyonder-capi/workflow-extensions-bundle
beyonder-capi/job-queue-bundle
capell-app/block-library
axium/identity
cetria/laravel-dummy-models
cetria/reflection-helper
agropredict/sso-auth-bundle
evolvestudio/spam-protection
datacore/hub-sdk
develia/commons
cuci/prototurk-sdk
cuci/prototurk-sdk-symfony
develia/geo-bundle
dreamzy/livewire-charts
touchestate-sdk/php-sdk
22h/doctrine-garbage-collection-bundle
agtp/agtp-php
agtp/mod-php
splash/sonata-admin