postgres cast string to boolean in where clause code example Example: postgresql cast SELECT '100'::INTEGER; SELECT CAST ('100' AS INTEGER);