graphile / graphile/postgis

Geometry subtype not inferred for function returns

Open
#41 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
90
Forks
13
PR merge metrics
No merged PRs in 30d

Description

With
```
"postgraphile": "4.12.2",
"@graphile/postgis": "0.1.0",
```

The following function will return a geometry interface as a return type instead of a point geometry. This is particularly frustrating for computed columns on tables (for example generating a centroid for a polygon geometry).

```pgsql
CREATE FUNCTION myschema.mytable_pos(mytable myschema.mytable) RETURNS geometry(Point,4326) AS $$
SELECT st_pointonsurface(geom)
$$ LANGUAGE sql STABLE
````

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.