ST_OrderingEquals´Â µÎ °³ÀÇ ±âÇÏÇÐÀ» ºñ±³ÇÏ¿© ±âÇÏÇÐÀÌ °°À¸¸é¼ ÁÂÇ¥°¡ µ¿ÀÏÇÑ ¼ø¼·Î µÇ¾î ÀÖÀ¸¸é 1(TRUE);À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_OrderingEquals(g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Integer
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº µÎ °³ÀÇ ¼±½ºÆ®¸µ Ä÷³ L1 ¹× L2°¡ ÀÖ´Â LINESTRING_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE LINESTRING_TEST (lid integer, l1 db2gse.ST_LineString, l2 db2gse.ST_LineString);
´ÙÀ½ÀÇ INSERT¹®Àº ³»¿ëµµ °°°í ÁÂÇ¥ ¼ø¼µµ µ¿ÀÏÇÑ L1 ¹× L2·Î µÎ ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù.
INSERT INTO linestring_test VALUES (1, db2gse.LineFromText('linestring (10.01 20.02, 21.50 12.10)', db2gse.coordref()..srid(0)), db2gse.LineFromText('linestring (10.01 20.02, 21.50 12.10)', db2gse.coordref()..srid(0)));
´ÙÀ½ÀÇ INSERT¹®Àº ³»¿ëÀº °°Áö¸¸ ÁÂÇ¥ ¼ø¼°¡ µ¿ÀÏÇÏÁö ¾ÊÀº L1 ¹× L2·Î µÎ ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù.
INSERT INTO linestring_test VALUES (2, db2gse.LineFromText('linestring (10.01 20.02, 21.50 12.10)', db2gse.coordref()..srid(0)), db2gse.LineFromText('linestring (21.50 12.10,10.01 20.02)', db2gse.coordref()..srid(0)));
´ÙÀ½ SELECT¹® ¹× °á°ú ¼¼Æ®¿¡ Ç¥½ÃµÈ °Íó·³ ST_OrderingEquals ÇÔ¼ö´Â,
SELECT lid, db2gse.ST_OrderingEquals(l1,l2) OrderingEquals FROM linestring_test lid OrderingEquals --- ----------- 1 1 2 0