Skip to content

v0.5.4b237

Pre-release
Pre-release

Choose a tag to compare

@jdrumgoole jdrumgoole released this 17 Jul 07:36

SQL: user-defined range types, and enum OIDs in every plan shape

A focused SQL-server release, both slices driven by the psycopg conformance gauge. CREATE TYPE ... AS RANGE brings user-defined range types end to end — catalog rows, the v3 extended protocol's binary codec path, and range operators over the new types — building on the range/multirange parameter support that shipped in the previous release. And enum result OIDs now survive every plan shape: joins, subqueries, set operations, and computed projections all report the enum's real pg_type OID in RowDescription (previously only simple scans did), with mood[]-style enum-array columns decoding correctly on the binary path.

Added

  • CREATE TYPE ... AS RANGE / DROP TYPE: catalog rows, binary codecs on the extended protocol, range operators over user-defined range types.
  • Enum result OIDs in RowDescription across joins, subqueries, set operations, and computed projections; enum-array (mood[]) columns on the binary path.

Excerpted verbatim from the changelog — full detail at https://secantusdb.com/docs/changelog.html.