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 :: syntax

SQL

SELECT 
  '100'::INTEGER AS string_to_int,
  CURRENT_DATE::TEXT AS date_to_string,
  '2024-01-01'::DATE AS string_to_date;

Tested against PostgreSQL 16

Note

“The :: operator is PostgreSQL-specific syntax for casting. It is concise and widely used.