Skip to content

Geography data type Method and prefSQL #53

@pfaeffli

Description

@pfaeffli

Describtion
We want to use the geography data type of Ms SQL. Some of these functions have to be called like geography::STGeomFromText(). prefSQL does not allow such calls.
It is of course not necessary that prefSQL has to support this.

Example Query

SELECT o.OBJ_ID as Id,
 geography::STGeomFromText('POINT (8.436462 47.147035)',
 4326) AS Rotkreuz,
 o.OBJ_KOORDINATEN.STDistance('POINT (8.436462 47.147035)',4326) AS DistanceToRotkreuz 
FROM T_Objekt o  
SKYLINE OF  o.OBJ_OBJEKTART ('Haus' >> OTHERS EQUAL),
 o.OBJ_KOORDINATEN.STDistance('POINT (8.436462 47.147035)',4326) LOW)

Exception
mismatched input ':' expecting {, ';', ',', '=', '*', '+', '-', '||', '/', '%', '<<', '>>', '&', '|', '<', '<=', '>', '>=', '==', '!=', '<>', K_AND, K_AS, K_BETWEEN, K_EXCEPT, K_FROM, K_IN, K_INTERSECT, K_IS, K_ISNULL, K_LIKE, K_MATCH, K_NOT, K_NOTNULL, K_OR, K_ORDER, K_UNION, K_WHERE, K_SKYLINE, K_GROUP, IDENTIFIER, STRING_LITERAL}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions