> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ST_LineSubstring

Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are Double values between 0 and 1. This only works with LINESTRINGs.

<img src="https://mintcdn.com/wherobots/fqh3gPDE0J25Lra_/images/sql-functions/ST_LineSubstring/ST_LineSubstring.svg?fit=max&auto=format&n=fqh3gPDE0J25Lra_&q=85&s=769b9a04d2ebfddbbf40d46bb26a7d33" alt="ST_LineSubstring" width="400" height="150" data-path="images/sql-functions/ST_LineSubstring/ST_LineSubstring.svg" />

## Signatures

```sql theme={"system"}
ST_LineSubstring (geom: Geometry, startfraction: Double, endfraction: Double)
```

## Parameters

<ParamField body="geom" type="Geometry" required>
  The input geometry.
</ParamField>

<ParamField body="startfraction" type="Double" required>
  The startfraction value.
</ParamField>

<ParamField body="endfraction" type="Double" required>
  The endfraction value.
</ParamField>

## Return type

<ResponseField type="Geometry">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
SELECT ST_LineSubstring(ST_GeomFromWKT('LINESTRING(25 50, 100 125, 150 190)'), 0.333, 0.666)
```

```
LINESTRING (69.28469348539744 94.28469348539744, 100 125, 111.70035626068274 140.21046313888758)
```