5 CREATE TABLE CIRCLE_TBL (f1 circle);
7 INSERT INTO CIRCLE_TBL VALUES ('<(5,1),3>');
9 INSERT INTO CIRCLE_TBL VALUES ('<(1,2),100>');
11 INSERT INTO CIRCLE_TBL VALUES ('1,3,5');
13 INSERT INTO CIRCLE_TBL VALUES ('((1,2),3)');
15 INSERT INTO CIRCLE_TBL VALUES ('<(100,200),10>');
17 INSERT INTO CIRCLE_TBL VALUES ('<(100,1),115>');
21 INSERT INTO CIRCLE_TBL VALUES ('<(-100,0),-100>');
23 INSERT INTO CIRCLE_TBL VALUES ('1abc,3,5');
25 INSERT INTO CIRCLE_TBL VALUES ('(3,(1,2),3)');
27 SELECT * FROM CIRCLE_TBL;
29 SELECT '' AS six, center(f1) AS center
32 SELECT '' AS six, radius(f1) AS radius
35 SELECT '' AS six, diameter(f1) AS diameter
38 SELECT '' AS two, f1 FROM CIRCLE_TBL WHERE radius(f1) < 5;
40 SELECT '' AS four, f1 FROM CIRCLE_TBL WHERE diameter(f1) >= 10;
42 SELECT '' as five, c1.f1 AS one, c2.f1 AS two, (c1.f1 <-> c2.f1) AS distance
43 FROM CIRCLE_TBL c1, CIRCLE_TBL c2
44 WHERE (c1.f1 < c2.f1) AND ((c1.f1 <-> c2.f1) > 0)
45 ORDER BY distance, area(c1.f1), area(c2.f1);