Skip to content

v18.0.2

Latest

Choose a tag to compare

@github-actions github-actions released this 17 Sep 17:14
· 1 commit to main since this release
389a7a7

This release fixes numeric results returned from functions declared as real or double precision, adds support for more PostgreSQL types, and updates PRQL and pgrx.

Correct Float Return Values

PL/PRQL now converts numeric query results to the function’s declared floating-point return type. This fixes incorrect results for scalar functions, set-returning functions, and table columns declared as real or double precision.

Many thanks to @Vonng for contributing this fix and the pgrx upgrade!

More PostgreSQL Types

Added support for dates, times, timestamps with and without time zones, intervals, UUIDs, and arrays of booleans, integers, floating-point numbers, and text.

Other Highlights

  • Updated the PRQL compiler to 0.13.14 and pgrx to 0.19.2.
  • Added PostgreSQL 19 prerelease testing on Linux and macOS. PostgreSQL 18 remains the default.
  • Building from source now requires Rust 1.96 or newer and cargo-pgrx 0.19.2.
  • Debian packages are available for PostgreSQL 13–18 on Bookworm and Trixie.

Upgrading

After installing the new package, reconnect to PostgreSQL and run this in each database using PL/PRQL:

ALTER EXTENSION plprql UPDATE TO '18.0.2';

What's Changed

  • feat: Add support for more PostgreSQL types by @kaspermarstal in #152
  • build(deps): Bump prqlc from 0.13.5 to 0.13.6 by @dependabot[bot] in #153
  • build(deps): Bump actions/checkout from 5 to 6 by @dependabot[bot] in #155
  • build(deps): Bump prqlc from 0.13.6 to 0.13.7 by @dependabot[bot] in #154
  • build(deps): Bump prqlc from 0.13.7 to 0.13.10 by @dependabot[bot] in #157
  • build(deps): Bump serde_json from 1.0.145 to 1.0.148 by @dependabot[bot] in #160
  • build(deps): Bump serde_json from 1.0.148 to 1.0.149 by @dependabot[bot] in #161
  • build(deps): Bump thiserror from 2.0.17 to 2.0.18 by @dependabot[bot] in #162
  • build(deps): Bump prqlc from 0.13.10 to 0.13.12 by @dependabot[bot] in #169
  • build(deps): Bump bytes from 1.10.1 to 1.11.1 in the cargo group across 1 directory by @dependabot[bot] in #163
  • build(deps): Bump the cargo group across 1 directory with 4 updates by @dependabot[bot] in #175
  • fix: coerce numeric results to declared float return types by @Vonng in #174
  • build(deps): Bump prqlc from 0.13.12 to 0.13.14 by @dependabot[bot] in #179
  • build(deps): Bump serde_json from 1.0.149 to 1.0.151 by @dependabot[bot] in #178
  • build(deps): Bump serde from 1.0.228 to 1.0.229 by @dependabot[bot] in #177
  • build(deps): Bump actions/checkout from 6 to 7 by @dependabot[bot] in #173
  • build(deps): Bump softprops/action-gh-release from 2 to 3 by @dependabot[bot] in #167
  • build(deps): Bump thiserror from 2.0.18 to 2.0.20 by @dependabot[bot] in #181
  • build(deps): upgrade pgrx to 0.19.2 by @Vonng in #176
  • ci: add PostgreSQL 19 coverage by @kaspermarstal in #182
  • chore: prepare v18.0.2 release by @kaspermarstal in #183

New Contributors

Full Changelog: v18.0.1...v18.0.2