© 2026 Hedgehog Software, LLC
jsonb
[ { "insuranceGTACode": "groupama", "excludedPostcodes": [], "supportedPostcodes": [], "excludedDepartments": [], "supportedDepartments": ["75","78","92","95","60"] } ]
return db .select({ email: wrecker.contactEmail, }) .from(wrecker) .where( and( sql`${wrecker.zones} @> '[{"insuranceGTACode": "groupama"}]'::jsonb`, sql`${wrecker.zones} @> '[{"supportedDepartments": ["75"]}]'::jsonb`, ), );
PostgresError: invalid input syntax for type json
const department = "75"; return db .select({ email: wrecker.contactEmail, }) .from(wrecker) .where( and( sql`${wrecker.zones} @> '[{"insuranceGTACode": "groupama"}]'::jsonb`, sql`${wrecker.zones} @> '[{"supportedDepartments": [${department}]}]'::jsonb`, ), );