SET datestyle = 'ISO, YMD'; SET timezone = 'UTC'; SELECT 42::int2::rdfnode; rdfnode ------------------------------------------------ "42"^^ (1 row) SELECT 4273::int4::rdfnode; rdfnode ------------------------------------------------ "4273"^^ (1 row) SELECT 123456789101112::int8::rdfnode; rdfnode ------------------------------------------------------------ "123456789101112"^^ (1 row) SELECT 42.12345::numeric::rdfnode; rdfnode -------------------------------------------------------- "42.12345"^^ (1 row) SELECT 42.1234::float4::rdfnode; rdfnode ----------------------------------------------------- "42.1234"^^ (1 row) SELECT 42.123456650::float8::rdfnode; rdfnode ---------------------------------------------------------- "42.12345665"^^ (1 row) SELECT 42.12345::double precision::rdfnode; rdfnode ------------------------------------------------------- "42.12345"^^ (1 row) SELECT true::rdfnode; rdfnode ---------------------------------------------------- "true"^^ (1 row) SELECT false::rdfnode; rdfnode ----------------------------------------------------- "false"^^ (1 row) SELECT '"rdf_fdw"'::rdfnode; rdfnode ----------- "rdf_fdw" (1 row) SELECT '"rdf_fdw"@en'::rdfnode; rdfnode -------------- "rdf_fdw"@en (1 row) SELECT '2025-01-01'::date::rdfnode; rdfnode ------------------------------------------------------- "2025-01-01"^^ (1 row) SELECT '18:30:25'::time without time zone::rdfnode; rdfnode ----------------------------------------------------- "18:30:25"^^ (1 row) SELECT '2025-01-01 18:30:25'::timestamp without time zone::rdfnode; rdfnode -------------------------------------------------------------------- "2025-01-01T18:30:25"^^ (1 row) SELECT '2025-01-01 18:30:25 UTC'::timestamp with time zone::rdfnode; rdfnode ---------------------------------------------------------------------------- "2025-01-01T18:30:25.000000Z"^^ (1 row) SELECT '1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds'::interval::rdfnode; rdfnode ---------------------------------------------------------------- "P1Y2M25DT5H6M7S"^^ (1 row) SELECT '"42"^^'::rdfnode::int2; int2 ------ 42 (1 row) SELECT '"4273"^^'::rdfnode::int4; int4 ------ 4273 (1 row) SELECT '"123456789101112"^^'::rdfnode::int8; int8 ----------------- 123456789101112 (1 row) SELECT '"42.12345"^^'::rdfnode::numeric; numeric ---------- 42.12345 (1 row) SELECT '"42.1234"^^'::rdfnode::float4; float4 --------- 42.1234 (1 row) SELECT '"42.123456650"^^'::rdfnode::float8; float8 ------------- 42.12345665 (1 row) SELECT '"true"^^'::rdfnode::boolean; bool ------ t (1 row) SELECT '"false"^^'::rdfnode::boolean; bool ------ f (1 row) SELECT '"rdf_fdw"'::rdfnode::text; text ----------- "rdf_fdw" (1 row) SELECT '"rdf_fdw"@en'::rdfnode::text; text -------------- "rdf_fdw"@en (1 row) SELECT '"2025-01-01"^^'::rdfnode::date; date ------------ 2025-01-01 (1 row) SELECT '"18:30:25"^^'::rdfnode::time without time zone; time ---------- 18:30:25 (1 row) SELECT '"2025-01-01T18:30:25"^^'::rdfnode::timestamp without time zone; timestamp --------------------- 2025-01-01 18:30:25 (1 row) SELECT '"2025-01-01T18:30:25Z"^^'::rdfnode::timestamp with time zone; timestamptz ------------------------ 2025-01-01 18:30:25+00 (1 row) SELECT '"P1Y2M25DT5H6M7S"^^'::rdfnode::interval; interval ----------------------------------------------- @ 1 year 2 mons 25 days 5 hours 6 mins 7 secs (1 row)