↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Mathematical Functions And Operators

Remainder of y/x; available for smallint, integer, bigint, and numeric

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

Signatures & examples

mod ( y numeric_type, x numeric_type ) → numeric_type
Remainder of y/x; available for smallint, integer, bigint, and numeric
mod(9, 4) → 1
Version history 1
  1. 12 → 13 changed

Definition snapshot: b7bd9cda · English manual source