How to remove the line from inside the circle? QGIS

Question

How to remove the line from inside the circle in QGIS?

Answer 1

To demonstrate

1. Create the x-point 0,0
2. Create the y-point 3,0
3. Create a circle around x-point with a radius of 1.
4. Create a line from x-y.
5. Find the difference between the line and the circle.
6. Returns that as ST_AsText

Code,

WITH data AS (
    SELECT
      x AS point,
      ST_Buffer(x,1) AS circle,
      ST_MakeLine(x,y) AS line
    FROM ( VALUES
      (ST_MakePoint(0,0), ST_MakePoint(3,0))
    ) AS t(x, y)
)
SELECT ST_AsText(ST_Difference(line, circle))
FROM data;

Returns

      st_astext      
---------------------
 LINESTRING(1 0,3 0)

This excludes the circle (0,0) with a radius of one