Casting

unlike T-SQL casting doesnt require the CAST(column AS TYPE) function. Instead, within postgres you can cast datatypes like column::datatype using the double colon syntax ::

SELECT product_id
     , model
     , year::TEXT
     , product_type
     , base_msrp
     , production_start_date
     , production_end_date
FROM products;

---

Backlinks

• Sql_for_data_analytics_perform_fast_and_efficient (DevLog)