Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyBasic SELECT

Cast data types using CAST() standard

SQL

SELECT 
  CAST('100' AS INTEGER),
  CAST(salary AS VARCHAR)
FROM employees;

Tested against PostgreSQL 16

Note

“CAST() is ANSI SQL standard. Does exactly the same thing as :: but is cross-database compatible.