st_setsrid missing in Postgis dialect

Description

The st_setsrid is missing in Postgis dialect. Is there a reason for this or would a dialect extension PR be appreciated? I haven't migrated to 5x yet, so I would like to patch it for 4x as well, would that be possible? (It affects both versions).

Quick fix:

  • Extend the Postgis dialect with your own version, and add
    this.registerFunction("setsrid", new StandardSQLFunction("st_setsrid", GeometryType.INSTANCE));

(For 5x the syntax seems slightly different)

Environment

None

Status

Assignee

Karel Maesen

Reporter

Jan-Willem Gmelig Meyling

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Trivial