DROP TABLE public.circle;
CREATE TABLE public.circle (id INTEGER, description VARCHAR);

SELECT AddGeometryColumn('public', 'circle', 'the_geom', -1, 'CIRCULARSTRING', 2);

INSERT INTO public.circle (
        id, 
        description
      ) VALUES (
        1, 
        'Circle');

UPDATE public.circle
        SET the_geom = geomfromewkt('CIRCULARSTRING(
                -10 0, 
                10 0,
                -10 0)')
        WHERE id = 1;

INSERT INTO public.circle (
        id, 
        description
      ) VALUES (
        2, 
        'Semi-circle');

UPDATE public.circle
        SET the_geom = geomfromewkt('CIRCULARSTRING(
                -10 0, 
                0 -10,
                10 0)')
        WHERE id = 2;

INSERT INTO public.circle (
        id, 
        description
      ) VALUES (
        3, 
        'Semi 8');

UPDATE public.circle
        SET the_geom = geomfromewkt('CIRCULARSTRING(
                -10 0, 
                0 -10,
                10 0,
                20 10,
                30 0)')
        WHERE id = 3;
        
-- Bounding boxes
SELECT Box2D (the_geom) FROM circle WHERE id = 1;
SELECT Box2D (the_geom) FROM circle WHERE id = 2;
SELECT Box2D (the_geom) FROM circle WHERE id = 3;

-- end