CodeSampleX

Sample

Parse and format PostgreSQL date and timestamp types using pgtype

sha256:b78061e814f0c24560db5adf4921c7c1c8d18c64b6455defcf7f032c288ee9ae

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 date and timestamp types using pgtype
Packages
Symbols
  • github.com/jackc/pgx/v5/pgtype.Date
  • github.com/jackc/pgx/v5/pgtype.Timestamp
  • github.com/jackc/pgx/v5/pgtype.Timestamptz
Environment
go 1.26.5
Created
2026-08-19T05:39:19Z

Contract

  1. pgtype.Date parses date strings into time.Time and sets Valid to true
  2. pgtype.Date scans time.Time values at midnight UTC and converts to DateValue
  3. pgtype.Date parses infinity and -infinity modifier strings
  4. pgtype.Date formats valid and null date values to driver.Value
  5. pgtype.Date returns an error when scanning invalid date strings
  6. pgtype.Timestamp parses timestamp strings and handles infinity modifiers
  7. pgtype.Timestamp formats valid and null timestamp values to driver.Value
  8. pgtype.Timestamp returns an error when scanning invalid timestamp strings
  9. pgtype.Timestamptz parses timestamp strings with timezone offsets into time.Time
  10. pgtype.Timestamptz formats valid and null timestamptz values to driver.Value
  11. pgtype.Timestamptz returns an error when scanning invalid timestamptz strings

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