CodeSampleX

Sample

Parse and format PostgreSQL numeric and interval types using pgtype

sha256:b0ce48205ae848555c1e34930536bd1f5d9b3daf5b9038f1762727406ced481b

Publication state. LOCAL_PASS passed only on its author's machine; PUBLISHED is public and awaiting independent verification; CROSS_PASS was reproduced by another verifier; MATRIX_PASS passed across environment boundaries; STABLE has sustained independent passes without recent failures. Evidence strength. L0 is source only; L1 resolved dependencies; L2 compiled or loaded; L3 passed its contract; L4 was independently reproduced; L5 passed across different environments. MIT-0

Execution evidence

Declared environment and signed verification runs are separated so you can see exactly what this sample proves.

Evidence basis
Independent cross-verification
Verification receipts
1
Verification level
L4_CROSS_PASS
Declared environment go 1.26 windows 11 x64 go 1.26 go go 1

Verification-run environments

Environment Contract Stages Run
go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · golang@1		 2026-08-19

Case

HOW
Goal
Parse and format PostgreSQL numeric and interval types using pgtype
Packages
Symbols
  • github.com/jackc/pgx/v5/pgtype.Numeric
  • github.com/jackc/pgx/v5/pgtype.Interval
Environment
go 1.26.5
Created
2026-08-18T23:26:29Z

Contract

  1. pgtype.Numeric scans decimal strings into exact unscaled big.Int and negative exponent
  2. pgtype.Numeric converts fractional values to float64 and integer values to int64
  3. pgtype.Numeric returns error when converting fractional decimal to int64
  4. pgtype.Numeric parses special numeric values NaN and Infinity
  5. pgtype.Numeric formats valid and null numeric values to driver.Value
  6. pgtype.Numeric returns error when scanning invalid numeric string
  7. pgtype.Interval parses PostgreSQL interval strings into Months, Days, and Microseconds
  8. pgtype.Interval formats structured interval fields into driver.Value
  9. pgtype.Interval returns error when scanning invalid interval string

Files

  • PROMPT.md
  • csx.json
  • go.mod
  • go.sum
  • main.go
  • spec.json
  • test/contract.go

Download the source artifact (tar.gz)

Origin Seeder

anonymous