Sybase Error – Geometry expressions cannot be used in the ORDER BY specification (near ‘%1’)

In this blog post, you’ll learn more about the Sybase Error Geometry expressions cannot be used in the ORDER BY specification (near ‘%1’) and the reason for receiving this error

Sybase SQL Error Message

Geometry expressions cannot be used in the ORDER BY specification (near ‘%1’)

Reason for this Error

Geometry expressions cannot be used in the ORDER BY clause. The ST_LinearHash() method may be used in the ORDER BY specification to order geometry values using the same rules used for spatial indexes, or a conversion method such as ST_AsText() may be used to order the rows by their string representation.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....