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 'Infinity'::numeric::rdfnode; rdfnode --------------------------------------------------- "INF"^^ (1 row) SELECT '-Infinity'::numeric::rdfnode; rdfnode ---------------------------------------------------- "-INF"^^ (1 row) SELECT 'Infinity'::float4::rdfnode; rdfnode ------------------------------------------------- "INF"^^ (1 row) SELECT '-Infinity'::float4::rdfnode; rdfnode -------------------------------------------------- "-INF"^^ (1 row) SELECT 'Infinity'::float8::rdfnode; rdfnode -------------------------------------------------- "INF"^^ (1 row) SELECT '-Infinity'::float8::rdfnode; rdfnode --------------------------------------------------- "-INF"^^ (1 row) SELECT 'Infinity'::double precision::rdfnode; rdfnode -------------------------------------------------- "INF"^^ (1 row) SELECT '-Infinity'::double precision::rdfnode; rdfnode --------------------------------------------------- "-INF"^^ (1 row) SELECT 'NaN'::numeric::rdfnode; rdfnode --------------------------------------------------- "NaN"^^ (1 row) SELECT 'NaN'::float4::rdfnode; rdfnode ------------------------------------------------- "NaN"^^ (1 row) SELECT 'NaN'::float8::rdfnode; rdfnode -------------------------------------------------- "NaN"^^ (1 row) SELECT 'NaN'::double precision::rdfnode; rdfnode -------------------------------------------------- "NaN"^^ (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 '18:30:25+02:00'::time with time zone::rdfnode; rdfnode ----------------------------------------------------------- "18:30:25+02:00"^^ (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:25Z"^^ (1 row) SELECT '1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds'::interval::rdfnode; rdfnode ---------------------------------------------------------------- "P1Y2M25DT5H6M7S"^^ (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 '"INF"^^'::rdfnode::numeric; numeric ---------- Infinity (1 row) SELECT '"-INF"^^'::rdfnode::numeric; numeric ----------- -Infinity (1 row) SELECT '"INF"^^'::rdfnode::float4; float4 ---------- Infinity (1 row) SELECT '"-INF"^^'::rdfnode::float4; float4 ----------- -Infinity (1 row) SELECT '"INF"^^'::rdfnode::float8; float8 ---------- Infinity (1 row) SELECT '"-INF"^^'::rdfnode::float8; float8 ----------- -Infinity (1 row) SELECT '"INF"^^'::rdfnode::double precision; float8 ---------- Infinity (1 row) SELECT '"-INF"^^'::rdfnode::double precision; float8 ----------- -Infinity (1 row) SELECT '"NaN"^^'::rdfnode::numeric; numeric --------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::float4; float4 -------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::float8; float8 -------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::double precision; float8 -------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::numeric; numeric --------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::float4; float4 -------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::float8; float8 -------- NaN (1 row) SELECT '"NaN"^^'::rdfnode::double precision; float8 -------- NaN (1 row) SELECT '"INF"^^'::rdfnode::float8::rdfnode; rdfnode -------------------------------------------------- "INF"^^ (1 row) SELECT '"-INF"^^'::rdfnode::float8::rdfnode; rdfnode --------------------------------------------------- "-INF"^^ (1 row) SELECT '"NaN"^^'::rdfnode::float8::rdfnode; rdfnode -------------------------------------------------- "NaN"^^ (1 row) SELECT '"true"^^'::rdfnode::boolean; bool ------ t (1 row) SELECT '"false"^^'::rdfnode::boolean; bool ------ f (1 row) SELECT '"1"^^'::rdfnode::boolean; bool ------ t (1 row) SELECT '"0"^^'::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+02:00"^^'::rdfnode::time with time zone; timetz ------------- 18:30:25+02 (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) SELECT '"-P1Y2M25DT5H6M7S"^^'::rdfnode::interval; interval --------------------------------------------------- @ 1 year 2 mons 25 days 5 hours 6 mins 7 secs ago (1 row)