SET timezone TO 'Etc/UTC'; CREATE SERVER wikidata FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://query.wikidata.org/sparql'); CREATE FOREIGN TABLE rdbms ( p rdfnode OPTIONS (variable '?p'), o rdfnode OPTIONS (variable '?o') ) SERVER wikidata OPTIONS ( log_sparql 'true', sparql 'SELECT * {wd:Q192490 ?p ?o}'); /* SPARQL 17.4.1.7 - RDFterm-equal */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND o = '"PostgreSQL"@de'; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = "PostgreSQL"@de) } INFO: SPARQL returned 1 record. p | o ----------------------------------------------+----------------- | "PostgreSQL"@de (1 row) /* SPARQL 17.4.1.9 - IN */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND o IN ('"PostgreSQL"@de', '"PostgreSQL"@es', '"PostgreSQL"@fr'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o IN ("PostgreSQL"@de, "PostgreSQL"@es, "PostgreSQL"@fr)) } INFO: SPARQL returned 3 records. p | o ----------------------------------------------+----------------- | "PostgreSQL"@de | "PostgreSQL"@es | "PostgreSQL"@fr (3 rows) /* SPARQL 17.4.1.10 - NOT IN*/ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND o NOT IN ('"PostgreSQL"@de', '"PostgreSQL"@es', '"PostgreSQL"@fr') LIMIT 5; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o NOT IN ("PostgreSQL"@de, "PostgreSQL"@es, "PostgreSQL"@fr)) } LIMIT 5 INFO: SPARQL returned 5 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@cs | "PostgreSQL"@en | "PostgreSQL"@af | "بوستجري إس كيو إل"@ar | "PostgreSQL"@az (5 rows) /* SPARQL 15.5 - LIMIT */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') LIMIT 5; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } LIMIT 5 INFO: SPARQL returned 5 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@cs | "PostgreSQL"@en | "PostgreSQL"@af | "بوستجري إس كيو إل"@ar | "PostgreSQL"@az (5 rows) SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') FETCH FIRST 5 ROWS ONLY; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } LIMIT 5 INFO: SPARQL returned 5 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@cs | "PostgreSQL"@en | "PostgreSQL"@af | "بوستجري إس كيو إل"@ar | "PostgreSQL"@az (5 rows) /* SPARQL 15.4 - OFFSET */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') OFFSET 5 ROWS FETCH FIRST 10 ROWS ONLY; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } LIMIT 15 INFO: SPARQL returned 15 records. p | o ----------------------------------------------+--------------------- | "PostgreSQL"@bg | "পোস্টগ্রেএসকিউএল"@bn | "PostgreSQL"@ca | "PostgreSQL"@da | "PostgreSQL"@de | "PostgreSQL"@el | "PostgreSQL"@eo | "PostgreSQL"@es | "PostgreSQL"@et | "PostgreSQL"@eu (10 rows) SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') OFFSET 5 ROWS LIMIT 10; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } LIMIT 15 INFO: SPARQL returned 15 records. p | o ----------------------------------------------+--------------------- | "PostgreSQL"@bg | "পোস্টগ্রেএসকিউএল"@bn | "PostgreSQL"@ca | "PostgreSQL"@da | "PostgreSQL"@de | "PostgreSQL"@el | "PostgreSQL"@eo | "PostgreSQL"@es | "PostgreSQL"@et | "PostgreSQL"@eu (10 rows) /* SPARQL 15.1 - ORDER BY */ SELECT p FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') ORDER BY p DESC LIMIT 3; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY DESC (?p) LIMIT 3 INFO: SPARQL returned 3 records. p ---------------------------------------------- (3 rows) SELECT p FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') ORDER BY p ASC LIMIT 3; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY ASC (?p) LIMIT 3 INFO: SPARQL returned 3 records. p ---------------------------------------------- (3 rows) SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') ORDER BY p DESC, o ASC LIMIT 3; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY DESC (?p) ASC (?o) LIMIT 3 INFO: SPARQL returned 3 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@af | "PostgreSQL"@az | "بوستجري إس كيو إل"@ar (3 rows) SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') ORDER BY p DESC, o ASC OFFSET 5 LIMIT 2; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY DESC (?p) ASC (?o) LIMIT 7 INFO: SPARQL returned 7 records. p | o ----------------------------------------------+------------------------ | "بوستجري إس كيو إل"@ar | "পোস্টগ্রেএসকিউএল"@bn (2 rows) SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') ORDER BY 1 DESC, 2 ASC OFFSET 5 LIMIT 10; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY DESC (?p) ASC (?o) LIMIT 15 INFO: SPARQL returned 15 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@da | "PostgreSQL"@de | "PostgreSQL"@el | "PostgreSQL"@en | "PostgreSQL"@eo | "PostgreSQL"@es | "PostgreSQL"@et | "PostgreSQL"@eu | "بوستجري إس كيو إل"@ar | "পোস্টগ্রেএসকিউএল"@bn (10 rows) /* SPARQL 18.2.5.3 - DISTINCT */ SELECT DISTINCT p FROM rdbms WHERE p = ''; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT DISTINCT ?p {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY ASC (?p) INFO: SPARQL returned 1 record. p ---------------------------------------------- (1 row) -- DISTINCT ON is not supported, therefore it won't be pushed down. SELECT DISTINCT ON (p) p,o FROM rdbms WHERE p = ''; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) } ORDER BY ASC (?p) INFO: SPARQL returned 58 records. p | o ----------------------------------------------+----------------- | "PostgreSQL"@cs (1 row) /* SPARQL - 17.3 Operator Mapping (text) */ SELECT p, o FROM rdbms WHERE p = '' AND p <> '' AND sparql.str(o) >= '"Postgre"' AND sparql.str(o) <= '"PostgreSQL Europe"' AND sparql.str(o) BETWEEN '"Postgre"' AND '"PostgreSQL Europe"' LIMIT 3; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?p != ) FILTER(STR(?o) >= "Postgre") FILTER(STR(?o) <= "PostgreSQL Europe") FILTER(STR(?o) >= "Postgre") FILTER(STR(?o) <= "PostgreSQL Europe") } LIMIT 3 INFO: SPARQL returned 3 records. p | o ----------------------------------------------+----------------- | "PostgreSQL"@cs | "PostgreSQL"@en | "PostgreSQL"@af (3 rows) /* SPARQL - 17.3 Operator Mapping (rdfnode) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND p <> ''::rdfnode AND sparql.str(o) >= 'Postgre'::rdfnode AND sparql.str(o) <= '"PostgreSQL Europe"'::rdfnode AND sparql.str(o) BETWEEN 'Postgre'::rdfnode AND '"PostgreSQL Europe"'::rdfnode LIMIT 3; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?p != ) FILTER(STR(?o) >= "Postgre") FILTER(STR(?o) <= "PostgreSQL Europe") FILTER(STR(?o) >= "Postgre") FILTER(STR(?o) <= "PostgreSQL Europe") } LIMIT 3 INFO: SPARQL returned 3 records. p | o ----------------------------------------------+----------------- | "PostgreSQL"@cs | "PostgreSQL"@en | "PostgreSQL"@af (3 rows) /* SPARQL - 17.3 Operator Mapping (smallint) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 31360::smallint AND o <> 10000::smallint AND o >= 31360::smallint AND o <= 31360::smallint AND o BETWEEN 31000 AND 31999 AND 31360::smallint = o AND 10000::smallint <> o AND 31360::smallint >= o AND 31360::smallint <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 31360) FILTER(?o != 10000) FILTER(?o >= 31360) FILTER(?o <= 31360) FILTER(?o >= 31000) FILTER(?o <= 31999) FILTER(31360 = ?o) FILTER(10000 != ?o) FILTER(31360 >= ?o) FILTER(31360 <= ?o) } INFO: SPARQL returned 1 record. p | o ---------------------------------------------+----------------------------------------------------- | "31360"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (int) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 31360::int AND o <> 10000::int AND o >= 31360::int AND o <= 31360::int AND o BETWEEN 31000 AND 31999 AND 31360::int = o AND 10000::int <> o AND 31360::int >= o AND 31360::int <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 31360) FILTER(?o != 10000) FILTER(?o >= 31360) FILTER(?o <= 31360) FILTER(?o >= 31000) FILTER(?o <= 31999) FILTER(31360 = ?o) FILTER(10000 != ?o) FILTER(31360 >= ?o) FILTER(31360 <= ?o) } INFO: SPARQL returned 1 record. p | o ---------------------------------------------+----------------------------------------------------- | "31360"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (bigint) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 2346087135::bigint AND o <> 9999999999::bigint AND o >= 2346087135::bigint AND o <= 2346087135::bigint AND o BETWEEN 2346087000::bigint AND 2346087999::bigint AND 2346087135::bigint = o AND 9999999999::bigint <> o AND 2346087135::bigint >= o AND 2346087135::bigint <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 2346087135) FILTER(?o != 9999999999) FILTER(?o >= 2346087135) FILTER(?o <= 2346087135) FILTER(?o >= 2346087000) FILTER(?o <= 2346087999) FILTER(2346087135 = ?o) FILTER(9999999999 != ?o) FILTER(2346087135 >= ?o) FILTER(2346087135 <= ?o) } INFO: SPARQL returned 1 record. p | o -----------------------------+---------------------------------------------------------- | "2346087135"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (real) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 31360.0::real AND o <> 10000::real AND o >= 31359.5::real AND o <= 31360.5::real AND o BETWEEN 31359.5::real AND 31360.5::real AND 31360.0::real = o AND 10000::real <> o AND 31360.5::real >= o AND 31359.5::real <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 31360) FILTER(?o != 10000) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(31360 = ?o) FILTER(10000 != ?o) FILTER(31360.5 >= ?o) FILTER(31359.5 <= ?o) } INFO: SPARQL returned 1 record. p | o ---------------------------------------------+----------------------------------------------------- | "31360"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (double precision) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 31360.0::double precision AND o <> 10000.99::double precision AND o >= 31359.5::double precision AND o <= 31360.5::double precision AND o BETWEEN 31359.5::double precision AND 31360.5::double precision AND 31360.0::double precision = o AND 10000.99::double precision <> o AND 31360.5::double precision >= o AND 31359.5::double precision <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 31360) FILTER(?o != 10000.99) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(31360 = ?o) FILTER(10000.99 != ?o) FILTER(31360.5 >= ?o) FILTER(31359.5 <= ?o) } INFO: SPARQL returned 1 record. p | o ---------------------------------------------+----------------------------------------------------- | "31360"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (numeric) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = 31360.0::numeric AND o <> 10000.99::numeric AND o >= 31359.5::numeric AND o <= 31360.5::numeric AND o BETWEEN 31359.5::numeric AND 31360.5::numeric AND 31360.0::numeric = o AND 10000.99::numeric <> o AND 31360.5::numeric >= o AND 31359.5::numeric <= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o = 31360.0) FILTER(?o != 10000.99) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(?o >= 31359.5) FILTER(?o <= 31360.5) FILTER(31360.0 = ?o) FILTER(10000.99 != ?o) FILTER(31360.5 >= ?o) FILTER(31359.5 <= ?o) } INFO: SPARQL returned 1 record. p | o ---------------------------------------------+----------------------------------------------------- | "31360"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (timestamp) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = '1996-01-01 00:00:00'::timestamp AND o <> '2000-01-31 18:30:00'::timestamp AND o >= '1996-01-01 00:00:00'::timestamp AND o <= '1996-01-01 00:00:00'::timestamp AND o BETWEEN '1990-01-01 00:00:00'::timestamp AND '2000-01-01 00:00:00'::timestamp AND '1996-01-01 00:00:00'::timestamp = o AND '2000-01-31 18:30:00'::timestamp <> o AND '1996-01-01 00:00:00'::timestamp <= o AND '1996-01-01 00:00:00'::timestamp >= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o != "2000-01-31T18:30:00"^^) FILTER(?o >= "1996-01-01T00:00:00"^^) FILTER(?o <= "1996-01-01T00:00:00"^^) FILTER(?o >= "1990-01-01T00:00:00"^^) FILTER(?o <= "2000-01-01T00:00:00"^^) FILTER("2000-01-31T18:30:00"^^ != ?o) FILTER("1996-01-01T00:00:00"^^ <= ?o) FILTER("1996-01-01T00:00:00"^^ >= ?o) FILTER(?o = "1996-01-01T00:00:00"^^) } INFO: SPARQL returned 1 record. p | o --------------------------------------------+--------------------------------------------------------------------- | "1996-01-01T00:00:00Z"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (timestamptz) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o = '1996-01-01 00:00:00'::timestamptz AND o <> '2000-01-31 18:30:00'::timestamptz AND o >= '1996-01-01 00:00:00'::timestamptz AND o <= '1996-01-01 00:00:00'::timestamptz AND o BETWEEN '1990-01-01 00:00:00'::timestamptz AND '2000-01-01 00:00:00'::timestamptz AND '1996-01-01 00:00:00'::timestamptz = o AND '2000-01-31 18:30:00'::timestamptz <> o AND '1996-01-01 00:00:00'::timestamptz <= o AND '1996-01-01 00:00:00'::timestamptz >= o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o != "2000-01-31T18:30:00.000000Z"^^) FILTER(?o >= "1996-01-01T00:00:00.000000Z"^^) FILTER(?o <= "1996-01-01T00:00:00.000000Z"^^) FILTER(?o >= "1990-01-01T00:00:00.000000Z"^^) FILTER(?o <= "2000-01-01T00:00:00.000000Z"^^) FILTER("2000-01-31T18:30:00.000000Z"^^ != ?o) FILTER("1996-01-01T00:00:00.000000Z"^^ <= ?o) FILTER("1996-01-01T00:00:00.000000Z"^^ >= ?o) FILTER(?o = "1996-01-01T00:00:00.000000Z"^^) } INFO: SPARQL returned 1 record. p | o --------------------------------------------+--------------------------------------------------------------------- | "1996-01-01T00:00:00Z"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (date) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') = '1996-01-01'::date AND sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') <> '2000-01-01'::date AND sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') >= '1996-01-01'::date AND sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') <= '1996-01-01'::date AND sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') BETWEEN '1990-01-01'::date AND '2000-01-01'::date AND '1996-01-01'::date = sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') AND '2000-01-01'::date <> sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') AND '1996-01-01'::date <= sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date') AND '1996-01-01'::date >= sparql.strdt(sparql.substr(sparql.str(o), 1, 10),'xsd:date'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) = "1996-01-01"^^) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) != "2000-01-01"^^) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) >= "1996-01-01"^^) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) <= "1996-01-01"^^) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) >= "1990-01-01"^^) FILTER(STRDT(SUBSTR(STR(?o), 1, 10), ) <= "2000-01-01"^^) FILTER("1996-01-01"^^ = STRDT(SUBSTR(STR(?o), 1, 10), )) FILTER("2000-01-01"^^ != STRDT(SUBSTR(STR(?o), 1, 10), )) FILTER("1996-01-01"^^ <= STRDT(SUBSTR(STR(?o), 1, 10), )) FILTER("1996-01-01"^^ >= STRDT(SUBSTR(STR(?o), 1, 10), )) } INFO: SPARQL returned 1 record. p | o --------------------------------------------+--------------------------------------------------------------------- | "1996-01-01T00:00:00Z"^^ (1 row) /* SPARQL - 17.3 Operator Mapping (timetz) */ SELECT p, o, sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') FROM rdbms WHERE p = ''::rdfnode AND sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') = '00:00:00 PST'::timetz AND sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') <> '23:00:00 PST'::timetz AND sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') >= '00:00:00 PST'::timetz AND sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') <= '00:00:00 PST'::timetz AND sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') BETWEEN '00:00:00 PST'::timetz AND '23:59:00 PST'::timetz AND '00:00:00 PST'::timetz = sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') AND '23:00:00 PST'::timetz <> sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') AND '00:00:00 PST'::timetz <= sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time') AND '00:00:00 PST'::timetz >= sparql.strdt(sparql.substr(sparql.str(o), 12, 8),'xsd:time'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) = "00:00:00-08"^^) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) != "23:00:00-08"^^) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) >= "00:00:00-08"^^) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) <= "00:00:00-08"^^) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) >= "00:00:00-08"^^) FILTER(STRDT(SUBSTR(STR(?o), 12, 8), ) <= "23:59:00-08"^^) FILTER("00:00:00-08"^^ = STRDT(SUBSTR(STR(?o), 12, 8), )) FILTER("23:00:00-08"^^ != STRDT(SUBSTR(STR(?o), 12, 8), )) FILTER("00:00:00-08"^^ <= STRDT(SUBSTR(STR(?o), 12, 8), )) FILTER("00:00:00-08"^^ >= STRDT(SUBSTR(STR(?o), 12, 8), )) } INFO: SPARQL returned 0 records. p | o | strdt ---+---+------- (0 rows) /* SPARQL - 17.3 Operator Mapping (boolean) */ SELECT p, o FROM rdbms WHERE p = ''::rdfnode AND o <> false AND o <> true AND false <> o AND true <> o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o != "false"^^) FILTER(?o != "true"^^) FILTER("false"^^ != ?o) FILTER("true"^^ != ?o) } INFO: SPARQL returned 0 records. p | o ---+--- (0 rows) /* SPARQL 17.4.1.1 - BOUND */ CREATE FOREIGN TABLE rdbms2 ( p rdfnode OPTIONS (variable '?p'), o rdfnode OPTIONS (variable '?o'), x rdfnode OPTIONS (variable '?x') ) SERVER wikidata OPTIONS ( log_sparql 'true', sparql 'SELECT * {wd:Q192490 ?p ?o OPTIONAL { ?o ?x }}'); SELECT p, o, sparql.bound(p), sparql.bound(x) FROM rdbms2 WHERE p = '' AND sparql.langmatches(sparql.lang(o),'es') AND sparql.bound(o) AND NOT sparql.bound(x); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o ?x {wd:Q192490 ?p ?o OPTIONAL { ?o ?x } ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "es")) FILTER(BOUND(?o)) } INFO: SPARQL returned 1 record. p | o | bound | bound ----------------------------------------------+-----------------+-------+------- | "PostgreSQL"@es | t | f (1 row) /* SPARQL 17.4.1.3 - COALESCE */ SELECT p, o, x, sparql.coalesce(x, o, p) FROM rdbms2 WHERE p = '' AND sparql.coalesce(x, o) = '"PostgreSQL"@de' AND sparql.coalesce(x, x, o) = '"PostgreSQL"@de' AND sparql.coalesce(x, p) = '' AND sparql.coalesce(x, x, p) = ''; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o ?x {wd:Q192490 ?p ?o OPTIONAL { ?o ?x } ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(COALESCE(?x, ?o) = "PostgreSQL"@de) FILTER(COALESCE(?x, ?x, ?o) = "PostgreSQL"@de) FILTER(COALESCE(?x, ?p) = ) FILTER(COALESCE(?x, ?x, ?p) = ) } INFO: SPARQL returned 1 record. p | o | x | coalesce ----------------------------------------------+-----------------+---+----------------- | "PostgreSQL"@de | | "PostgreSQL"@de (1 row) /* SPARQL 17.4.1.8 - sameTerm */ SELECT p, o, sparql.sameterm(o,'"PostgreSQL"@fr') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.sameterm(o,'"PostgreSQL"@fr') AND sparql.sameterm(p,''); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(SAMETERM(?o, "PostgreSQL"@fr)) FILTER(SAMETERM(?p, )) } INFO: SPARQL returned 1 record. p | o | sameterm ----------------------------------------------+-----------------+---------- | "PostgreSQL"@fr | t (1 row) /* SPARQL 17.4.1.9 - IN */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND o IN ('"PostgreSQL"@de'::rdfnode, '"PostgreSQL"@en', sparql.strlang('PostgreSQL','es')); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o IN ("PostgreSQL"@de, "PostgreSQL"@en, "PostgreSQL"@es)) } INFO: SPARQL returned 3 records. p | o ----------------------------------------------+----------------- | "PostgreSQL"@en | "PostgreSQL"@de | "PostgreSQL"@es (3 rows) /* SPARQL 17.4.1.10 - NOT IN */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND o NOT IN ('"PostgreSQL"@de'::rdfnode, '"PostgreSQL"@en', sparql.strlang('PostgreSQL','es')) FETCH FIRST 3 ROWS ONLY; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(?o NOT IN ("PostgreSQL"@de, "PostgreSQL"@en, "PostgreSQL"@es)) } LIMIT 3 INFO: SPARQL returned 3 records. p | o ----------------------------------------------+------------------------ | "PostgreSQL"@cs | "PostgreSQL"@af | "بوستجري إس كيو إل"@ar (3 rows) /* SPARQL 17.4.2.1 - isIRI */ SELECT p, o, sparql.isIRI(p), sparql.isIRI(o) FROM rdbms WHERE p = '' AND sparql.isIRI(p) AND NOT sparql.isIRI(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(isIRI(?p)) } INFO: SPARQL returned 1 record. p | o | isiri | isiri ---------------------------------------------+--------------+-------+------- | "PostgreSQL" | t | f (1 row) /* SPARQL 17.4.2.2 - isBlank */ SELECT p, o, sparql.isblank(o) FROM rdbms WHERE sparql.isblank(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(ISBLANK(?o)) } INFO: SPARQL returned 0 records. p | o | isblank ---+---+--------- (0 rows) /* SPARQL 17.4.2.3 - isLiteral */ SELECT p, o, sparql.isliteral(o), sparql.isliteral(p) FROM rdbms WHERE p = '' AND sparql.isliteral(o) AND NOT sparql.isliteral(p); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(ISLITERAL(?o)) } INFO: SPARQL returned 1 record. p | o | isliteral | isliteral ---------------------------------------------+--------------+-----------+----------- | "PostgreSQL" | t | f (1 row) /* SPARQL 17.4.2.4 - isNumeric */ SELECT p, o, sparql.isnumeric(o), sparql.isnumeric(p) FROM rdbms WHERE p = '' AND sparql.isnumeric(o) AND NOT sparql.isnumeric(p); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(ISNUMERIC(?o)) } INFO: SPARQL returned 1 record. p | o | isnumeric | isnumeric -----------------------------+----------------------------------------------------------+-----------+----------- | "2346087135"^^ | t | f (1 row) /* SPARQL 17.4.2.5 - str */ SELECT p, o, sparql.str(o) FROM rdbms WHERE p = '' AND sparql.str(o) = sparql.str('"PostgreSQL"@fr') FETCH FIRST ROW ONLY; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(STR(?o) = "PostgreSQL") } LIMIT 1 INFO: SPARQL returned 1 record. p | o | str ----------------------------------------------+-----------------+-------------- | "PostgreSQL"@cs | "PostgreSQL" (1 row) /* SPARQL 17.4.2.6 - lang */ SELECT p, o, sparql.lang(o) FROM rdbms WHERE p = '' AND sparql.lang(o) = sparql.lang('"PostgreSQL"@pt'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANG(?o) = "pt") } INFO: SPARQL returned 1 record. p | o | lang ----------------------------------------------+-----------------+------ | "PostgreSQL"@pt | pt (1 row) /* SPARQL 17.4.2.7 - datatype */ SELECT p, o, sparql.datatype(o) FROM rdbms WHERE p = '' AND sparql.datatype(o) = sparql.datatype('"2346087135"^^'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(DATATYPE(?o) = ) } INFO: SPARQL returned 1 record. p | o | datatype -----------------------------+----------------------------------------------------------+-------------------------------------------- | "2346087135"^^ | (1 row) /* SPARQL 17.4.2.8 - IRI */ SELECT p, o, sparql.iri(p) FROM rdbms WHERE sparql.iri(p) = sparql.iri('http://www.wikidata.org/prop/direct/P13337') AND sparql.iri('') = sparql.iri(p) AND sparql.iri('http://www.wikidata.org/prop/direct/P13337') = p AND p = sparql.iri('http://www.wikidata.org/prop/direct/P13337'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(IRI(?p) = ) FILTER( = IRI(?p)) FILTER( = ?p) FILTER(?p = ) } INFO: SPARQL returned 1 record. p | o | iri ----------------------------------------------+------------------+---------------------------------------------- | "postgresql.org" | (1 row) /* SPARQL 17.4.2.9 - BNODE */ SELECT p, o, sparql.bnode(o) FROM rdbms WHERE p = '' AND sparql.isblank(sparql.bnode(o)); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(ISBLANK(BNODE(?o))) } INFO: SPARQL returned 1 record. p | o | bnode ----------------------------------------------+------------------+------------------ | "postgresql.org" | _:postgresql_org (1 row) /* SPARQL 17.4.2.10 - STRDT */ SELECT p, o, sparql.strdt(o,'xsd:string') FROM rdbms WHERE p = sparql.iri('') AND '"2346087135"^^xsd:string'::rdfnode = sparql.strdt(sparql.str(o),'xsd:string') AND sparql.strdt(sparql.str(o),'xsd:string') = '"2346087135"^^xsd:string'::rdfnode AND sparql.strdt(sparql.str('"2346087135"^^xsd:integer'),'xsd:string') = sparql.strdt(sparql.str(o),'xsd:string') AND sparql.strdt(sparql.str(o),'xsd:string') = sparql.strdt(sparql.str('"2346087135"^^xsd:integer'),'xsd:string'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER("2346087135"^^ = STRDT(STR(?o), )) FILTER(STRDT(STR(?o), ) = "2346087135"^^) FILTER("2346087135"^^ = STRDT(STR(?o), )) FILTER(STRDT(STR(?o), ) = "2346087135"^^) } INFO: SPARQL returned 1 record. p | o | strdt -----------------------------+----------------------------------------------------------+--------------------------------------------------------- | "2346087135"^^ | "2346087135"^^ (1 row) /* SPARQL 17.4.2.11 - STRLANG */ SELECT p, o, sparql.strlang(o,'en') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'en') AND sparql.strlang(sparql.str(o),'en') = sparql.strlang('"PostgreSQL"', 'en') AND sparql.strlang('"PostgreSQL"', 'en') = sparql.strlang(sparql.str(o),'en') AND sparql.strlang('"PostgreSQL"', 'en') = '"PostgreSQL"@en' AND '"PostgreSQL"@en' = sparql.strlang('"PostgreSQL"', 'en'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "en")) FILTER(STRLANG(STR(?o), "en") = "PostgreSQL"@en) FILTER("PostgreSQL"@en = STRLANG(STR(?o), "en")) } INFO: SPARQL returned 1 record. p | o | strlang ----------------------------------------------+-----------------+----------------- | "PostgreSQL"@en | "PostgreSQL"@en (1 row) /* SPARQL 17.4.2.12 - UUID (not pushable) */ SELECT sparql.uuid()::text ~ '^$'; ?column? ---------- t (1 row) /*SPARQL 17.4.2.13 - STRUUID (not pushable) */ SELECT sparql.struuid()::text ~ '^"[0-9a-f]{8}-[0-9a-f]{4}-4[0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}"$'; ?column? ---------- t (1 row) /* SPARQL 17.4.3.2 - STRLEN */ SELECT p, o, sparql.strlen(o) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'de') AND sparql.strlen(o) = sparql.strlen('"PostgreSQL"@de') AND sparql.strlen(o) = 10 AND 10 = sparql.strlen(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "de")) FILTER(STRLEN(?o) = 10) } INFO: SPARQL returned 1 record. p | o | strlen ----------------------------------------------+-----------------+-------- | "PostgreSQL"@de | 10 (1 row) /* SPARQL 17.4.3.3 - SUBSTR */ SELECT p, o, sparql.substr(o, 8, 3) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'es') AND sparql.substr(o, 8, 3) = sparql.substr('"PostgreSQL"@es', 8, 3) AND sparql.substr('"PostgreSQL"@es', 8, 3) = sparql.substr(o, 8, 3); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "es")) FILTER(SUBSTR(?o, 8, 3) = "SQL"@es) FILTER("SQL"@es = SUBSTR(?o, 8, 3)) } INFO: SPARQL returned 1 record. p | o | substr ----------------------------------------------+-----------------+---------- | "PostgreSQL"@es | "SQL"@es (1 row) /* SPARQL 17.4.3.4 - UCASE */ SELECT p, o, sparql.ucase(o) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.ucase(o) = sparql.ucase('"PostgreSQL"@fr') AND sparql.ucase(o) = '"POSTGRESQL"@fr' AND '"POSTGRESQL"@fr' = sparql.ucase(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(UCASE(?o) = "POSTGRESQL"@fr) FILTER(UCASE(?o) = "POSTGRESQL"@fr) FILTER("POSTGRESQL"@fr = UCASE(?o)) } INFO: SPARQL returned 1 record. p | o | ucase ----------------------------------------------+-----------------+----------------- | "PostgreSQL"@fr | "POSTGRESQL"@fr (1 row) /* SPARQL 17.4.3.5 - LCASE */ SELECT p, o, sparql.lcase(o) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.lcase(o) = sparql.lcase('"PostgreSQL"@es') AND sparql.lcase(o) = '"postgresql"@es' AND '"postgresql"@es' = sparql.lcase(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LCASE(?o) = "postgresql"@es) FILTER(LCASE(?o) = "postgresql"@es) FILTER("postgresql"@es = LCASE(?o)) } INFO: SPARQL returned 1 record. p | o | lcase ----------------------------------------------+-----------------+----------------- | "PostgreSQL"@es | "postgresql"@es (1 row) /* SPARQL 17.4.3.6 - STRSTARTS */ SELECT p, o, sparql.strstarts(o, sparql.str('"Postgre"@de')) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'de') AND sparql.strstarts(o,'"Postgre"@de'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "de")) FILTER(STRSTARTS(?o, "Postgre"@de)) } INFO: SPARQL returned 1 record. p | o | strstarts ----------------------------------------------+-----------------+----------- | "PostgreSQL"@de | t (1 row) /* SPARQL 17.4.3.7 - STRENDS */ SELECT p, o, sparql.strends(o, sparql.str('"SQL"@fr')) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'fr') AND sparql.strends(o,'"SQL"'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "fr")) FILTER(STRENDS(?o, "SQL")) } INFO: SPARQL returned 1 record. p | o | strends ----------------------------------------------+-----------------+--------- | "PostgreSQL"@fr | t (1 row) /* SPARQL 17.4.3.8 - CONTAINS */ SELECT p, o, sparql.contains(o,'"SQL"@it'), sparql.contains(o,'"SQL"^^xsd:string') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'it') AND sparql.contains(o,'"SQL"@') AND sparql.contains(o,'"Postgre"'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "it")) FILTER(CONTAINS(?o, "SQL")) FILTER(CONTAINS(?o, "Postgre")) } INFO: SPARQL returned 1 record. p | o | contains | contains ----------------------------------------------+-----------------+----------+---------- | "PostgreSQL"@it | t | t (1 row) /* SPARQL 17.4.3.9 - STRBEFORE */ SELECT p, o, sparql.strbefore(sparql.str(o), '"SQL"') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'fr') AND sparql.strbefore(sparql.str(o), '"SQL"') = sparql.strbefore(sparql.str('"PostgreSQL"@fr'),'"SQL"') AND sparql.strbefore(sparql.str(o), '"SQL"') = '"Postgre"' AND '"Postgre"' = sparql.strbefore(sparql.str(o), '"SQL"'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "fr")) FILTER(STRBEFORE(STR(?o), "SQL") = "Postgre") FILTER(STRBEFORE(STR(?o), "SQL") = "Postgre") FILTER("Postgre" = STRBEFORE(STR(?o), "SQL")) } INFO: SPARQL returned 1 record. p | o | strbefore ----------------------------------------------+-----------------+----------- | "PostgreSQL"@fr | "Postgre" (1 row) /* SPARQL 17.4.3.10 - STRAFTER */ SELECT p, o, sparql.strafter(sparql.str(o), '"Postgre"') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'es') AND sparql.strafter(sparql.str(o), '"Postgre"') = sparql.strafter(sparql.str('"PostgreSQL"@es'),'"Postgre"') AND sparql.strafter(sparql.str(o), '"Postgre"') = '"SQL"'::rdfnode AND '"SQL"' = sparql.strafter(sparql.str(o), '"Postgre"'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "es")) FILTER(STRAFTER(STR(?o), "Postgre") = "SQL") FILTER(STRAFTER(STR(?o), "Postgre") = "SQL") FILTER("SQL" = STRAFTER(STR(?o), "Postgre")) } INFO: SPARQL returned 1 record. p | o | strafter ----------------------------------------------+-----------------+---------- | "PostgreSQL"@es | "SQL" (1 row) /* SPARQL 17.4.3.11 - ENCODE_FOR_URI */ SELECT p, o, sparql.encode_for_uri(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.langmatches(sparql.lang(o),'de') AND sparql.encode_for_uri(o) = sparql.encode_for_uri('"relationales Datenbankmanagementsystem"@de') AND sparql.encode_for_uri(o) = '"relationales%20Datenbankmanagementsystem"' AND '"relationales%20Datenbankmanagementsystem"' = sparql.encode_for_uri(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "de")) FILTER(ENCODE_FOR_URI(?o) = "relationales%20Datenbankmanagementsystem") FILTER(ENCODE_FOR_URI(?o) = "relationales%20Datenbankmanagementsystem") FILTER("relationales%20Datenbankmanagementsystem" = ENCODE_FOR_URI(?o)) } INFO: SPARQL returned 1 record. p | o | encode_for_uri ---------------------------------+---------------------------------------------+-------------------------------------------- | "relationales Datenbankmanagementsystem"@de | "relationales%20Datenbankmanagementsystem" (1 row) /* 17.4.3.12 - CONCAT */ SELECT p, o, sparql.concat(o,sparql.strlang(' Global','es')), sparql.concat(o,'" Global"^^xsd:string') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'es') AND sparql.concat(o,' Global') = sparql.concat('"PostgreSQL"@es','" Global"') AND sparql.concat('"PostgreSQL"@es','" Global"') = sparql.concat(o,' Global'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "es")) FILTER(CONCAT(?o, " Global") = "PostgreSQL Global") FILTER("PostgreSQL Global" = CONCAT(?o, " Global")) } INFO: SPARQL returned 1 record. p | o | concat | concat ----------------------------------------------+-----------------+------------------------+--------------------- | "PostgreSQL"@es | "PostgreSQL Global"@es | "PostgreSQL Global" (1 row) /* SPARQL 17.4.3.13 - langMatches */ SELECT p, o, sparql.langmatches(sparql.lang(o),'*'), sparql.langmatches(sparql.lang(o),'fr'), sparql.langmatches(sparql.lang(o),'de') FROM rdbms WHERE sparql.langmatches(sparql.lang(o),'fr') ORDER BY p, o; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(LANGMATCHES(LANG(?o), "fr")) } ORDER BY ASC (?p) ASC (?o) INFO: SPARQL returned 3 records. p | o | langmatches | langmatches | langmatches ------------------------------------------------+----------------------------------------------------------------+-------------+-------------+------------- | "système libre de gestion de base de données relationnelle"@fr | t | t | f | "PostgreSQL"@fr | t | t | f | "Postgres"@fr | t | t | f (3 rows) /* SPARQL 17.4.3.14 - REGEX */ SELECT p, o FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'it') AND sparql.regex(o, sparql.ucase('postgres'), 'i') AND sparql.regex(o, '^pOs','i') ; INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "it")) FILTER(REGEX(?o, "POSTGRES", "i")) FILTER(REGEX(?o, "^pOs", "i")) } INFO: SPARQL returned 1 record. p | o ----------------------------------------------+----------------- | "PostgreSQL"@it (1 row) /* SPARQL 17.4.3.15 - REPLACE */ SELECT p, o, sparql.replace(o,'Postgre','My'), sparql.replace(o,'"Postgre"@fr',''), sparql.replace(o,'Postgre','My') = sparql.replace(sparql.strlang('PostgreSQL','fr'),'Postgre','My') FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'es') AND sparql.replace(sparql.str(o),'Postgre','My') = '"MySQL"'::rdfnode AND '"MySQL"' = sparql.replace(sparql.str(o),'Postgre','My') AND sparql.replace(sparql.str(o), 'POSTGRE', 'My','i') = sparql.replace('"PostgreSQL"', 'POSTGRE', 'My','i'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "es")) FILTER(REPLACE(STR(?o), "Postgre", "My") = "MySQL") FILTER("MySQL" = REPLACE(STR(?o), "Postgre", "My")) FILTER(REPLACE(STR(?o), "POSTGRE", "My", "i") = "MySQL") } INFO: SPARQL returned 1 record. p | o | replace | replace | ?column? ----------------------------------------------+-----------------+---------+---------+---------- | "PostgreSQL"@es | "MySQL" | "SQL" | t (1 row) /* SPARQL 17.4.4.1 - abs */ SELECT p, o, sparql.abs(o) FROM rdbms WHERE p = ''::rdfnode AND sparql.abs(o) = 2346087135::bigint AND sparql.abs(o) <> 9999999999::bigint AND sparql.abs(o) >= 2346087135::bigint AND sparql.abs(o) <= 2346087135::bigint AND sparql.abs(o) BETWEEN 2346087000::bigint AND 2346087999::bigint AND sparql.abs(o) = '"2346087135"^^xsd:long'::rdfnode AND sparql.abs(o) > '"1111111111"^^xsd:long'::rdfnode AND sparql.abs(o) >= '"2346087135"^^xsd:long'::rdfnode AND sparql.abs(o) < '"9999999999"^^xsd:long'::rdfnode AND sparql.abs(o) <= '"2346087135"^^xsd:long'::rdfnode AND 2346087135::bigint = sparql.abs(o) AND '"2346087135"^^xsd:long'::rdfnode = sparql.abs(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(ABS(?o) = 2346087135) FILTER(ABS(?o) != 9999999999) FILTER(ABS(?o) >= 2346087135) FILTER(ABS(?o) <= 2346087135) FILTER(ABS(?o) >= 2346087000) FILTER(ABS(?o) <= 2346087999) FILTER(ABS(?o) = "2346087135"^^) FILTER(ABS(?o) > "1111111111"^^) FILTER(ABS(?o) >= "2346087135"^^) FILTER(ABS(?o) < "9999999999"^^) FILTER(ABS(?o) <= "2346087135"^^) FILTER(2346087135 = ABS(?o)) FILTER("2346087135"^^ = ABS(?o)) } INFO: SPARQL returned 1 record. p | o | abs -----------------------------+----------------------------------------------------------+---------------------------------------------------------- | "2346087135"^^ | "2346087135"^^ (1 row) /* SPARQL 17.4.4.2 - round */ SELECT p, o, sparql.round(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.round(o) = sparql.round(31359.9) AND sparql.round(o) > 10000.9 AND sparql.round(o) >= sparql.round(31359.9) AND sparql.round(o) < 99999.9 AND sparql.round(o) <= sparql.round(31359.9) AND sparql.round(o) = '"31360"^^xsd:decimal'::rdfnode AND sparql.round(o) > '"10000.9"^^xsd:decimal'::rdfnode AND sparql.round(o) >= '"31360"^^xsd:decimal'::rdfnode AND sparql.round(o) < '"99999.9"^^xsd:decimal'::rdfnode AND sparql.round(o) <= '"31360"^^xsd:decimal'::rdfnode AND sparql.round(31359.9) = sparql.round(o) AND sparql.round('"31359.9"^^xsd:decimal'::rdfnode) = sparql.round(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(ROUND(?o) = "31360"^^) FILTER(ROUND(?o) > 10000.9) FILTER(ROUND(?o) >= "31360"^^) FILTER(ROUND(?o) < 99999.9) FILTER(ROUND(?o) <= "31360"^^) FILTER(ROUND(?o) = "31360"^^) FILTER(ROUND(?o) > "10000.9"^^) FILTER(ROUND(?o) >= "31360"^^) FILTER(ROUND(?o) < "99999.9"^^) FILTER(ROUND(?o) <= "31360"^^) FILTER("31360"^^ = ROUND(?o)) FILTER("31360"^^ = ROUND(?o)) } INFO: SPARQL returned 1 record. p | o | round ---------------------------------------------+-----------------------------------------------------+----------------------------------------------------- | "31360"^^ | "31360"^^ (1 row) /* SPARQL 17.4.4.3 - ceil */ SELECT p, o, sparql.round(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.ceil(o) = sparql.ceil(31359.5) AND sparql.ceil(o) > 10000 AND sparql.ceil(o) >= sparql.ceil(31359.5) AND sparql.ceil(o) < 99999.9 AND sparql.ceil(o) <= sparql.ceil(31359.5) AND sparql.ceil(o) = '"31360"^^xsd:decimal'::rdfnode AND sparql.ceil(o) > '"10000"^^xsd:decimal'::rdfnode AND sparql.ceil(o) >= '"31360"^^xsd:decimal'::rdfnode AND sparql.ceil(o) < '"99999"^^xsd:decimal'::rdfnode AND sparql.ceil(o) <= sparql.ceil('"31359.5"^^xsd:decimal'::rdfnode) AND sparql.ceil(31359.5) = sparql.ceil(o) AND sparql.ceil('"31359.5"^^xsd:decimal'::rdfnode) = sparql.ceil(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(CEIL(?o) = "31360"^^) FILTER(CEIL(?o) > 10000) FILTER(CEIL(?o) >= "31360"^^) FILTER(CEIL(?o) < 99999.9) FILTER(CEIL(?o) <= "31360"^^) FILTER(CEIL(?o) = "31360"^^) FILTER(CEIL(?o) > "10000"^^) FILTER(CEIL(?o) >= "31360"^^) FILTER(CEIL(?o) < "99999"^^) FILTER(CEIL(?o) <= "31360"^^) FILTER("31360"^^ = CEIL(?o)) FILTER("31360"^^ = CEIL(?o)) } INFO: SPARQL returned 1 record. p | o | round ---------------------------------------------+-----------------------------------------------------+----------------------------------------------------- | "31360"^^ | "31360"^^ (1 row) /* SPARQL 17.4.4.4 - floor */ SELECT p, o, sparql.round(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.floor(o) = sparql.floor(31360.5) AND sparql.floor(o) > 10000 AND sparql.floor(o) >= sparql.floor(31360.5) AND sparql.floor(o) < 99999.9 AND sparql.floor(o) <= sparql.floor(31360.5) AND sparql.floor(o) = '"31360"^^xsd:decimal'::rdfnode AND sparql.floor(o) > '"10000"^^xsd:decimal'::rdfnode AND sparql.floor(o) >= '"31360"^^xsd:decimal'::rdfnode AND sparql.floor(o) < '"99999"^^xsd:decimal'::rdfnode AND sparql.floor(o) <= sparql.floor('"31360.5"^^xsd:decimal'::rdfnode) AND sparql.floor(31360.5) = sparql.floor(o) AND sparql.floor('"31360.5"^^xsd:decimal'::rdfnode) = sparql.floor(o); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(FLOOR(?o) = "31360"^^) FILTER(FLOOR(?o) > 10000) FILTER(FLOOR(?o) >= "31360"^^) FILTER(FLOOR(?o) < 99999.9) FILTER(FLOOR(?o) <= "31360"^^) FILTER(FLOOR(?o) = "31360"^^) FILTER(FLOOR(?o) > "10000"^^) FILTER(FLOOR(?o) >= "31360"^^) FILTER(FLOOR(?o) < "99999"^^) FILTER(FLOOR(?o) <= "31360"^^) FILTER("31360"^^ = FLOOR(?o)) FILTER("31360"^^ = FLOOR(?o)) } INFO: SPARQL returned 1 record. p | o | round ---------------------------------------------+-----------------------------------------------------+----------------------------------------------------- | "31360"^^ | "31360"^^ (1 row) /* SPARQL 17.4.4.5 - RAND */ SELECT setseed(0.42); setseed --------- (1 row) SELECT sparql.lex(sparql.rand())::numeric BETWEEN 0.0 AND 1.0, sparql.datatype(sparql.rand()) = ''; ?column? | ?column? ----------+---------- t | t (1 row) /* SPARQL 17.4.5.2 - year*/ SELECT p, o, sparql.year(o) FROM rdbms WHERE p = sparql.iri('http://www.wikidata.org/prop/direct/P571') AND sparql.year(o) = 1996 AND sparql.year(o) > 1990 AND sparql.year(o) < 2000 AND sparql.year(o) >= 1996 AND sparql.year(o) <= 1996 AND sparql.year(o) = sparql.year('"1996-01-01T00:00:00Z"^^xsd:dateTime') AND sparql.year(o) > sparql.year('"1990-01-12T20:00:00"^^xsd:dateTime') AND sparql.year(o) < sparql.year('"2000-01-12T20:00:00"^^xsd:dateTime') AND sparql.year(o) >= sparql.year('"1996-01-01T00:00:00Z"^^xsd:dateTime') AND sparql.year(o) <= sparql.year('"1996-01-01T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(YEAR(?o) > 1990) FILTER(YEAR(?o) < 2000) FILTER(YEAR(?o) >= 1996) FILTER(YEAR(?o) <= 1996) FILTER(YEAR(?o) > YEAR("1990-01-12T20:00:00"^^)) FILTER(YEAR(?o) < YEAR("2000-01-12T20:00:00"^^)) FILTER(YEAR(?o) >= YEAR("1996-01-01T00:00:00Z"^^)) FILTER(YEAR(?o) <= YEAR("1996-01-01T00:00:00Z"^^)) FILTER(YEAR(?o) = 1996) FILTER(YEAR("1996-01-01T00:00:00Z"^^) = 1996) } INFO: SPARQL returned 1 record. p | o | year --------------------------------------------+---------------------------------------------------------------------+------ | "1996-01-01T00:00:00Z"^^ | 1996 (1 row) /* SPARQL 17.4.5.3 - month */ SELECT p, o, sparql.month(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.month(o) = 07 AND sparql.month(o) > 01 AND sparql.month(o) < 12 AND sparql.month(o) >= 07 AND sparql.month(o) <= 07 AND sparql.month(o) = sparql.month('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.month(o) > sparql.month('"1999-01-12T20:00:00"^^xsd:dateTime') AND sparql.month(o) < sparql.month('"2000-12-12T20:00:00"^^xsd:dateTime') AND sparql.month(o) >= sparql.month('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.month(o) <= sparql.month('"1996-07-08T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(MONTH(?o) > 1) FILTER(MONTH(?o) < 12) FILTER(MONTH(?o) >= 7) FILTER(MONTH(?o) <= 7) FILTER(MONTH(?o) > MONTH("1999-01-12T20:00:00"^^)) FILTER(MONTH(?o) < MONTH("2000-12-12T20:00:00"^^)) FILTER(MONTH(?o) >= MONTH("1996-07-08T00:00:00Z"^^)) FILTER(MONTH(?o) <= MONTH("1996-07-08T00:00:00Z"^^)) FILTER(MONTH(?o) = 7) FILTER(MONTH("1996-07-08T00:00:00Z"^^) = 7) } INFO: SPARQL returned 1 record. p | o | month --------------------------------------------+---------------------------------------------------------------------+------- | "1996-07-08T00:00:00Z"^^ | 7 (1 row) /* SPARQL 17.4.5.4 - day */ SELECT p, o, sparql.day(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.day(o) = 08 AND sparql.day(o) > 01 AND sparql.day(o) < 30 AND sparql.day(o) >= 08 AND sparql.day(o) <= 08 AND sparql.day(o) = sparql.day('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.day(o) > sparql.day('"1999-01-01T20:00:00"^^xsd:dateTime') AND sparql.day(o) < sparql.day('"2000-12-30T20:00:00"^^xsd:dateTime') AND sparql.day(o) >= sparql.day('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.day(o) <= sparql.day('"1996-07-08T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(DAY(?o) > 1) FILTER(DAY(?o) < 30) FILTER(DAY(?o) >= 8) FILTER(DAY(?o) <= 8) FILTER(DAY(?o) > DAY("1999-01-01T20:00:00"^^)) FILTER(DAY(?o) < DAY("2000-12-30T20:00:00"^^)) FILTER(DAY(?o) >= DAY("1996-07-08T00:00:00Z"^^)) FILTER(DAY(?o) <= DAY("1996-07-08T00:00:00Z"^^)) FILTER(DAY(?o) = 8) FILTER(DAY("1996-07-08T00:00:00Z"^^) = 8) } INFO: SPARQL returned 1 record. p | o | day --------------------------------------------+---------------------------------------------------------------------+----- | "1996-07-08T00:00:00Z"^^ | 8 (1 row) /* SPARQL 7.4.5.5 - hours */ SELECT p, o, sparql.hours(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.hours(o) = 0 AND sparql.hours(o) > -1 AND sparql.hours(o) < 23 AND sparql.hours(o) >= 0 AND sparql.hours(o) <= 0 AND sparql.hours(o) = sparql.hours('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND --sparql.hours(o) > sparql.hours('"1999-01-01T20:00:00"^^xsd:dateTime') AND sparql.hours(o) < sparql.hours('"2000-12-30T23:00:00"^^xsd:dateTime') AND sparql.hours(o) >= sparql.hours('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.hours(o) <= sparql.hours('"1996-07-08T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(HOURS(?o) > -1) FILTER(HOURS(?o) < 23) FILTER(HOURS(?o) >= 0) FILTER(HOURS(?o) <= 0) FILTER(HOURS(?o) < HOURS("2000-12-30T23:00:00"^^)) FILTER(HOURS(?o) >= HOURS("1996-07-08T00:00:00Z"^^)) FILTER(HOURS(?o) <= HOURS("1996-07-08T00:00:00Z"^^)) FILTER(HOURS(?o) = 0) FILTER(HOURS("1996-07-08T00:00:00Z"^^) = 0) } INFO: SPARQL returned 1 record. p | o | hours --------------------------------------------+---------------------------------------------------------------------+------- | "1996-07-08T00:00:00Z"^^ | 0 (1 row) /* SPARQL 17.4.5.6 - minutes */ SELECT p, o, sparql.minutes(o) FROM rdbms WHERE p = sparql.iri('') AND sparql.minutes(o) = 0 AND sparql.minutes(o) > -1 AND sparql.minutes(o) < 59 AND sparql.minutes(o) >= 0 AND sparql.minutes(o) <= 0 AND sparql.minutes(o) = sparql.minutes('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND --sparql.minutes(o) > sparql.minutes('"1999-01-01T20:00:00"^^xsd:dateTime') AND sparql.minutes(o) < sparql.minutes('"2000-12-30T23:59:59"^^xsd:dateTime') AND sparql.minutes(o) >= sparql.minutes('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.minutes(o) <= sparql.minutes('"1996-07-08T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(MINUTES(?o) > -1) FILTER(MINUTES(?o) < 59) FILTER(MINUTES(?o) >= 0) FILTER(MINUTES(?o) <= 0) FILTER(MINUTES(?o) < MINUTES("2000-12-30T23:59:59"^^)) FILTER(MINUTES(?o) >= MINUTES("1996-07-08T00:00:00Z"^^)) FILTER(MINUTES(?o) <= MINUTES("1996-07-08T00:00:00Z"^^)) FILTER(MINUTES(?o) = 0) FILTER(MINUTES("1996-07-08T00:00:00Z"^^) = 0) } INFO: SPARQL returned 1 record. p | o | minutes --------------------------------------------+---------------------------------------------------------------------+--------- | "1996-07-08T00:00:00Z"^^ | 0 (1 row) /* SPARQL 17.4.5.7 - seconds */ SELECT p, o, sparql.ceil(sparql.seconds(o)) FROM rdbms WHERE p = sparql.iri('') AND sparql.seconds(o) = 0 AND sparql.seconds(o) > -1 AND sparql.seconds(o) < 59 AND sparql.seconds(o) >= 0 AND sparql.seconds(o) <= 0 AND sparql.seconds(o) = sparql.seconds('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND --sparql.seconds(o) > sparql.seconds('"1999-01-01T20:00:00"^^xsd:dateTime') AND sparql.seconds(o) < sparql.seconds('"2000-12-30T23:59:59"^^xsd:dateTime') AND sparql.seconds(o) >= sparql.seconds('"1996-07-08T00:00:00Z"^^xsd:dateTime') AND sparql.seconds(o) <= sparql.seconds('"1996-07-08T00:00:00Z"^^xsd:dateTime'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(SECONDS(?o) > -1) FILTER(SECONDS(?o) < 59) FILTER(SECONDS(?o) >= 0) FILTER(SECONDS(?o) <= 0) FILTER(SECONDS(?o) < SECONDS("2000-12-30T23:59:59"^^)) FILTER(SECONDS(?o) >= SECONDS("1996-07-08T00:00:00Z"^^)) FILTER(SECONDS(?o) <= SECONDS("1996-07-08T00:00:00Z"^^)) FILTER(SECONDS(?o) = 0) FILTER(SECONDS("1996-07-08T00:00:00Z"^^) = 0) } INFO: SPARQL returned 1 record. p | o | ceil --------------------------------------------+---------------------------------------------------------------------+------------------------------------------------- | "1996-07-08T00:00:00Z"^^ | "0"^^ (1 row) /* SPARQL 17.4.5.8 - timezone */ SELECT sparql.timezone('"2011-01-10T14:45:13.815-05:00"^^xsd:dateTime'); timezone ------------------------------------------------------------- "-PT5H"^^ (1 row) /* SPARQL 7.4.5.9 - tz */ SELECT sparql.tz('"2011-01-10T14:45:13.815-05:00"^^xsd:dateTime'); tz ---------- "-05:00" (1 row) /* SPARQL 17.4.6.1 - MD5 */ SELECT p, o, sparql.md5(o) FROM rdbms WHERE p = sparql.iri('http://www.w3.org/2000/01/rdf-schema#label') AND sparql.langmatches(sparql.lang(o),'en') AND sparql.md5(o) = sparql.md5('"PostgreSQL"@en'); INFO: SPARQL query sent to 'https://query.wikidata.org/sparql': SELECT ?p ?o {wd:Q192490 ?p ?o ## rdf_fdw pushdown conditions ## FILTER(?p = ) FILTER(LANGMATCHES(LANG(?o), "en")) FILTER(MD5(?o) = MD5("PostgreSQL"@en)) } INFO: SPARQL returned 1 record. p | o | md5 ----------------------------------------------+-----------------+------------------------------------ | "PostgreSQL"@en | "399bd1ee587245ecac6f39beaa99886f" (1 row) DROP SERVER wikidata CASCADE; NOTICE: drop cascades to 2 other objects DETAIL: drop cascades to foreign table rdbms drop cascades to foreign table rdbms2