Controls how spatial values are converted from a geometry to binary.
The list of values supported for this option is identical to the list of parameters (including sub-parameters) documented for the ST_AsBinary method.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
This option is used to determine how a geometry is converted to binary. The following are the two main contexts in which the option is used:
fetching a value as binary from a client application
executing a CAST statement. For example: CAST( geometry-expression AS LONG BINARY )
Assignments from geometry types to BINARY types give an error in contexts other than fetching from a client application and the CAST statement. For example, you cannot call a function or procedure that takes a BINARY parameter and pass a geometry, nor can you assign a geometry to a LONG BINARY variable.