A modern programming language that makes developers happier.

kotlinlang

Hi there, I'm using a database with `PostGIS` support, and I'd like to call a `PostGIS` function during an insert, but I really can't figure out how to do this. I've seen examples involving `ExpressionWithColumnType`, but nothing that actually uses this function during an `insert` in a `transaction`. Some relevant code:

```abstract class SQLFunction&lt;T&gt;(override val columnType: IColumnType) : ExpressionWithColumnType&lt;T&gt;()

class ST_Centroid(private val poly: MultiPolygon): SQLFunction&lt;Point&gt;(PointColumnType()) {
    override fun toSQL(queryBuilder: QueryBuilder) = "ST_Centroid($poly)"
}```

I'm trying to do this now:
`[DbFields.center] = ST_Centroid(boundaryPoly)` where `boundaryPoly` is a PostGIS multipolygon.

Any help would be greatly appreciated :slightly_smiling_face:

Try:
```
FooTable.insert{
  it.update(FooTable.point, ST_Centroid(polygon))
}
```