Home
last modified time | relevance | path

Searched refs:ST_X (Results 1 – 25 of 517) sorted by relevance

12345678910>>...21

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/t/
H A Dst_x.test1 # This test tests the ST_X function.
4 SELECT ST_X(NULL);
5 SELECT ST_X(NULL, NULL);
6 SELECT ST_X(NULL, 1);
7 SELECT ST_X(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL);
11 DO ST_X(x'000000000123456789abcdef');
26 DO ST_X(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 0));
30 DO ST_X(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 0));
71 SELECT ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 0));
75 SELECT ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 3857));
[all …]
H A Dspatial_utility_functions_xy.test58 --echo # ST_X(point)
90 --echo # ST_X(point)
97 SELECT ST_ASTEXT(ST_X(NULL, 5));
98 SELECT ST_ASTEXT(ST_X(POINT(4, 5), NULL));
99 SELECT ST_ASTEXT(ST_X(NULL, NULL));
101 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(NULL), NULL));
116 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('NULL'), NULL));
166 SELECT ST_X(POINT(pow(2, 2048), 4), 5);
173 SELECT ST_X(POINT(4, pow(2, 2048)), 5);
176 SELECT ST_X(POINT(4, 5), pow(2, 2048));
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/r/
H A Dst_x.result2 SELECT ST_X(NULL);
3 ST_X(NULL)
5 SELECT ST_X(NULL, NULL);
6 ST_X(NULL, NULL)
8 SELECT ST_X(NULL, 1);
9 ST_X(NULL, 1)
12 ST_X(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL)
15 DO ST_X(x'000000000123456789abcdef');
74 ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 0))
81 ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 3857))
[all …]
H A Dspatial_utility_functions_xy.result41 # ST_X(point)
83 # ST_X(point)
85 SELECT ST_ASTEXT(ST_X(NULL, 5));
86 ST_ASTEXT(ST_X(NULL, 5))
88 SELECT ST_ASTEXT(ST_X(POINT(4, 5), NULL));
89 ST_ASTEXT(ST_X(POINT(4, 5), NULL))
91 SELECT ST_ASTEXT(ST_X(NULL, NULL));
92 ST_ASTEXT(ST_X(NULL, NULL))
141 SELECT ST_X(POINT(pow(2, 2048), 4), 5);
147 SELECT ST_X(POINT(4, pow(2, 2048)), 5);
[all …]
/dports/databases/postgis32/postgis-3.2.0/regress/core/
H A Dpoint_coordinates.sql1 SELECT 'X1', ST_X('POINT (0 0)'::geometry);
2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry);
3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry);
4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry);
5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry);
6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry);
7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry);
8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
H A Dquantize_coordinates.sql8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord…
10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC…
13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
H A Dpoint_coordinates_expected5 ERROR: Argument to ST_X() must have type POINT
6 ERROR: Argument to ST_X() must have type POINT
7 ERROR: Argument to ST_X() must have type POINT
8 ERROR: Argument to ST_X() must have type POINT
/dports/databases/postgis30/postgis-3.0.4/regress/core/
H A Dpoint_coordinates.sql1 SELECT 'X1', ST_X('POINT (0 0)'::geometry);
2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry);
3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry);
4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry);
5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry);
6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry);
7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry);
8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
H A Dquantize_coordinates.sql8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord…
10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC…
13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
H A Dpoint_coordinates_expected5 ERROR: Argument to ST_X() must have type POINT
6 ERROR: Argument to ST_X() must have type POINT
7 ERROR: Argument to ST_X() must have type POINT
8 ERROR: Argument to ST_X() must have type POINT
/dports/databases/postgis31/postgis-3.1.4/regress/core/
H A Dpoint_coordinates.sql1 SELECT 'X1', ST_X('POINT (0 0)'::geometry);
2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry);
3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry);
4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry);
5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry);
6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry);
7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry);
8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
H A Dquantize_coordinates.sql8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord…
10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC…
13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
H A Dpoint_coordinates_expected5 ERROR: Argument to ST_X() must have type POINT
6 ERROR: Argument to ST_X() must have type POINT
7 ERROR: Argument to ST_X() must have type POINT
8 ERROR: Argument to ST_X() must have type POINT
/dports/games/libretro-prboom/libretro-prboom-cc80175/src/
H A Dst_stuff.c69 #define ST_FX (ST_X+143)
100 #define ST_FACESX (ST_X+143)
125 #define ST_AMMOX (ST_X+44)
133 #define ST_HEALTHX (ST_X+90)
140 #define ST_ARMSX (ST_X+111)
153 #define ST_FRAGSX (ST_X+138)
162 #define ST_ARMORX (ST_X+221)
171 #define ST_KEY0X (ST_X+239)
177 #define ST_KEY1X (ST_X+239)
183 #define ST_KEY2X (ST_X+239)
[all …]
/dports/games/prboom/prboom-2.5.0/src/
H A Dst_stuff.c65 #define ST_X 0 macro
69 #define ST_FX (ST_X+143)
100 #define ST_FACESX (ST_X+143)
125 #define ST_AMMOX (ST_X+44)
133 #define ST_HEALTHX (ST_X+90)
140 #define ST_ARMSX (ST_X+111)
142 #define ST_ARMSBGX (ST_X+104)
153 #define ST_FRAGSX (ST_X+138)
162 #define ST_ARMORX (ST_X+221)
171 #define ST_KEY0X (ST_X+239)
[all …]
/dports/games/prboom-plus/prboom-plus-2.5.1.3/src/
H A Dst_stuff.c70 #define ST_X 0 macro
74 #define ST_FX (ST_X+143)
105 #define ST_FACESX (ST_X+143)
130 #define ST_AMMOX (ST_X+44)
138 #define ST_HEALTHX (ST_X+90)
145 #define ST_ARMSX (ST_X+111)
147 #define ST_ARMSBGX (ST_X+104)
158 #define ST_FRAGSX (ST_X+138)
167 #define ST_ARMORX (ST_X+221)
176 #define ST_KEY0X (ST_X+239)
[all …]
/dports/databases/postgis25/postgis-2.5.5/regress/
H A Dquantize_coordinates.sql8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord…
10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC…
13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
/dports/databases/pgrouting/pgrouting-3.2.0/sql/topology/
H A DextractVertices.sql183 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, in_edges, out_edges, ST_X(geom), …
202 SELECT DISTINCT ST_X(startpoint) AS x, ST_Y(startpoint) AS y, startpoint AS geom
207 SELECT DISTINCT ST_X(endpoint) AS x, ST_Y(endpoint) AS y, endpoint AS geom
217 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, NULL::BIGINT[], NULL::BIGINT[], …
257 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, in_edges, out_edges, ST_X(geom),…
271 SELECT DISTINCT ST_X(startpoint) AS x, ST_Y(startpoint) AS y, startpoint AS geom
276 SELECT DISTINCT ST_X(endpoint) AS x, ST_Y(endpoint) AS y, endpoint AS geom
286 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, NULL::BIGINT[], NULL::BIGINT[], …
/dports/databases/rrdtool/rrdtool-1.7.2/tests/
H A Dcreate-with-source-365 ST_X=$ST
108 $RRDTOOL create ${PREFIX}a2_x.rrd --start $ST_X --step 60 --source ${PREFIX}ab2_xy.rrd DS:a:GAUGE:1…
116 $RRDTOOL create ${PREFIX}b2_x.rrd --start $ST_X --step 60 --source ${PREFIX}ab2_xy.rrd DS:b:GAUGE:1…
127 $RRDTOOL dump ${PREFIX}a1_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}a1_y.xml
128 $RRDTOOL dump ${PREFIX}a2_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}a2_y.xml
136 $RRDTOOL dump ${PREFIX}b1_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}b1_y.xml
137 $RRDTOOL dump ${PREFIX}b2_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}b2_y.xml
/dports/databases/spatialite/libspatialite-5.0.1/test/sql_stmt_tests/
H A Dst_x1.testcase3 SELECT ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 4326));
6 ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 4326))
H A Dst_x7.testcase3 SELECT ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 0.0038723129645, 4326));
6 ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 0.0038723129645, 4326))
H A Dst_x8.testcase3 SELECT ST_X(MakePointM(-71.1043443253471, 42.3150676015829, 12.6389, 4326));
6 ST_X(MakePointM(-71.1043443253471, 42.3150676015829, 12.6389, 4326))
H A Dst_x9.testcase3 SELECT ST_X(MakePointZM(-71.1043443253471, 42.3150676015829, 0.0038723129645, 12.6389, 4326));
6 ST_X(MakePointZM(-71.1043443253471, 42.3150676015829, 0.0038723129645, 12.6389, 4326))
H A Dst_x6.testcase3 SELECT ST_X(zeroblob(10));
6 ST_X(zeroblob(10))
H A Dst_x4.testcase3 SELECT ST_X(GeomFromText('POINTM(136 -35 -8.6)'));
6 ST_X(GeomFromText('POINTM(136 -35 -8.6)'))

12345678910>>...21