Encode Inet as PostgreSQL inet via postgresql-types binary encoder

Encode Interval as PostgreSQL interval via postgresql-types binary encoder

Encode Point as PostgreSQL point via postgresql-types binary encoder

Encode Polygon as PostgreSQL polygon via postgresql-types binary encoder

Encode Tsvector as PostgreSQL tsvector via postgresql-types binary encoder

Encode Integer as PostgreSQL int8 (bigint) Used for BigInt and BigSerial columns

Encode Int as PostgreSQL int8 (bigint)

This treats Haskell's Int as Int64, which is safe on 64-bit platforms (where Int is 64 bits) and may truncate on 32-bit platforms (where Int is 32 bits but int8 can hold the full range).

Encode Id table' for tables with UUID primary keys This covers the common case in IHP where most tables use UUID as the primary key.

Encode 'Binary ByteString' as PostgreSQL bytea IHP wraps bytea columns in Binary, so we need to unwrap before encoding

Encode 'Vector Int' as PostgreSQL int8[] (bigint array)

Encode 'Maybe (Id' table)' for nullable foreign keys

Encode 'Maybe (Binary ByteString)' as nullable PostgreSQL bytea

Encode 'Maybe Inet' as nullable PostgreSQL inet

Encode 'Maybe Interval' as nullable PostgreSQL interval

Encode 'Maybe Point' as nullable PostgreSQL point

Encode 'Maybe Polygon' as nullable PostgreSQL polygon

Encode 'Maybe Tsvector' as nullable PostgreSQL tsvector

Encode 'Maybe Integer' as nullable PostgreSQL int8

Encode 'Maybe Int' as nullable PostgreSQL int8

Encode list of Id table' for tables with UUID primary keys Used by filterWhereIdIn for simple primary keys

Encode '[Maybe (Id' table)]' for filterWhereIn with nullable foreign keys

Encode '[Maybe Int]' as PostgreSQL int8[] with nullable elements

Encode '[(Id' a, Id' b)]' as PostgreSQL array of composite types Used by filterWhereIdIn for tables with composite primary keys of two Id columns

Encode '[(UUID, UUID)]' as PostgreSQL array of composite types Used by filterWhereIdIn for tables with composite primary keys of two UUIDs

Encode '[Int]' as PostgreSQL int8[] (bigint array)

Encode '(Id' a, Id' b)' as PostgreSQL composite/record type Used for composite primary keys with two Id columns (where both resolve to UUID)

Encode '(UUID, UUID)' as PostgreSQL composite/record type Used for composite primary keys with two UUID columns