»ç¿ëÀÚ ¾È³» ¹× ÂüÁ¶¼­

ST_OrderingEquals

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


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]