27 #include "../postgis_config.h"
36 #include "access/gist.h"
37 #include "access/itup.h"
40 #include "utils/elog.h"
41 #include "mb/pg_wchar.h"
42 #include "lib/stringinfo.h"
43 #include "utils/array.h"
44 #include "utils/builtins.h"
45 #include "utils/lsyscache.h"
49 #include "lwgeom_pg.h"
51 #include "lwgeom_transform.h"
54 #include "access/htup_details.h"
87 char *input = PG_GETARG_CSTRING(0);
88 int32 geom_typmod = -1;
95 if ( (PG_NARGS()>2) && (!PG_ARGISNULL(2)) ) {
96 geom_typmod = PG_GETARG_INT32(2);
102 if ( str[0] ==
'\0' ) {
103 ereport(ERROR,(errmsg(
"parse error - invalid geometry")));
108 if( strncasecmp(str,
"SRID=",5) == 0 )
112 while ( tmp && *tmp !=
';' )
116 if ( tmp && *(tmp+1) ==
'0' )
132 size_t hexsize = strlen(str);
149 PG_PARSER_ERROR(lwg_parser_result);
152 lwgeom = lwg_parser_result.
geom;
159 if ( geom_typmod >= 0 )
162 POSTGIS_DEBUG(3,
"typmod and geometry were consistent");
166 POSTGIS_DEBUG(3,
"typmod was -1");
172 PG_RETURN_POINTER(ret);
202 GSERIALIZED *pg_lwgeom = PG_GETARG_GSERIALIZED_P(0);
203 text *format_text = PG_GETARG_TEXT_P(1);
206 char *format_str = NULL;
208 char * formatted_str;
209 text * formatted_text;
216 lwpgerror(
"Only points are supported, you tried type %s.",
lwtype_name(geom_type));
221 if (format_text == NULL) {
222 lwpgerror(
"ST_AsLatLonText: invalid format string (null");
227 assert(format_str != NULL);
231 tmp = (
char *)pg_do_encoding_conversion(
232 (
uint8_t *)format_str, strlen(format_str), GetDatabaseEncoding(), PG_UTF8);
234 if ( tmp != format_str ) {
241 assert(formatted_str != NULL);
245 tmp = (
char *)pg_do_encoding_conversion(
246 (
uint8_t *)formatted_str, strlen(formatted_str),
247 PG_UTF8, GetDatabaseEncoding());
249 if ( tmp != formatted_str) {
250 pfree(formatted_str);
255 formatted_text = cstring_to_text(formatted_str);
256 pfree(formatted_str);
258 PG_RETURN_POINTER(formatted_text);
280 PG_RETURN_CSTRING(hexwkb);
299 if ( (PG_NARGS()>1) && (!PG_ARGISNULL(1)) )
301 type = PG_GETARG_TEXT_P(1);
303 if ( ! strncmp(VARDATA(
type),
"xdr", 3) ||
304 ! strncmp(VARDATA(
type),
"XDR", 3) )
320 text_size = hexwkb_size - 1 + VARHDRSZ;
321 result = palloc(text_size);
322 memcpy(VARDATA(result), hexwkb, hexwkb_size - 1);
323 SET_VARSIZE(result, text_size);
327 PG_FREE_IF_COPY(geom, 0);
328 PG_RETURN_TEXT_P(result);
354 result = cstring_to_text(hexwkb);
358 PG_FREE_IF_COPY(geom, 0);
359 PG_RETURN_TEXT_P(result);
372 bytea *bytea_wkb = (bytea*)PG_GETARG_BYTEA_P(0);
380 if ( ( PG_NARGS()>1) && ( ! PG_ARGISNULL(1) ))
382 srid = PG_GETARG_INT32(1);
391 PG_FREE_IF_COPY(bytea_wkb, 0);
392 PG_RETURN_POINTER(geom);
402 bytea *bytea_twkb = (bytea*)PG_GETARG_BYTEA_P(0);
414 PG_FREE_IF_COPY(bytea_twkb, 0);
415 PG_RETURN_POINTER(geom);
433 if ( (PG_NARGS()>1) && (!PG_ARGISNULL(1)) )
435 type = PG_GETARG_TEXT_P(1);
437 if ( ! strncmp(VARDATA(
type),
"xdr", 3) ||
438 ! strncmp(VARDATA(
type),
"XDR", 3) )
447 wkb_size= VARSIZE(geom) - VARHDRSZ;
455 result = palloc(wkb_size + VARHDRSZ);
456 memcpy(VARDATA(result), wkb, wkb_size);
457 SET_VARSIZE(result, wkb_size+VARHDRSZ);
461 PG_FREE_IF_COPY(geom, 0);
462 PG_RETURN_BYTEA_P(result);
478 if ( PG_ARGISNULL(0) ) PG_RETURN_NULL();
480 geom = PG_GETARG_GSERIALIZED_P(0);
486 if ( PG_NARGS() > 1 && ! PG_ARGISNULL(1) )
487 sp.precision_xy = PG_GETARG_INT32(1);
490 if ( PG_NARGS() > 2 && ! PG_ARGISNULL(2) )
491 sp.precision_z = PG_GETARG_INT32(2);
494 if ( PG_NARGS() > 3 && ! PG_ARGISNULL(3) )
495 sp.precision_m = PG_GETARG_INT32(3);
501 if ( PG_NARGS() > 4 && ! PG_ARGISNULL(4) && PG_GETARG_BOOL(4) )
505 if ( PG_NARGS() > 5 && ! PG_ARGISNULL(5) && PG_GETARG_BOOL(5) )
513 result = palloc(twkb_size + VARHDRSZ);
514 memcpy(VARDATA(result), twkb, twkb_size);
515 SET_VARSIZE(result, twkb_size + VARHDRSZ);
517 PG_RETURN_BYTEA_P(result);
524 ArrayType *arr_geoms = NULL;
525 ArrayType *arr_ids = NULL;
526 int num_geoms, num_ids, i = 0;
528 ArrayIterator iter_geoms, iter_ids;
529 bool null_geom, null_id;
530 Datum val_geom, val_id;
532 int is_homogeneous =
true;
537 int64_t *idlist = NULL;
546 if ( PG_NARGS() < 2 || PG_ARGISNULL(0) || PG_ARGISNULL(1) )
549 arr_geoms = PG_GETARG_ARRAYTYPE_P(0);
550 arr_ids = PG_GETARG_ARRAYTYPE_P(1);
552 num_geoms = ArrayGetNItems(ARR_NDIM(arr_geoms), ARR_DIMS(arr_geoms));
553 num_ids = ArrayGetNItems(ARR_NDIM(arr_ids), ARR_DIMS(arr_ids));
555 if ( num_geoms != num_ids )
557 elog(ERROR,
"size of geometry[] and integer[] arrays must match");
564 #if POSTGIS_PGSQL_VERSION >= 95
565 iter_geoms = array_create_iterator(arr_geoms, 0, NULL);
566 iter_ids = array_create_iterator(arr_ids, 0, NULL);
568 iter_geoms = array_create_iterator(arr_geoms, 0);
569 iter_ids = array_create_iterator(arr_ids, 0);
572 while( array_iterate(iter_geoms, &val_geom, &null_geom) &&
573 array_iterate(iter_ids, &val_id, &null_id) )
578 if ( null_geom || null_id )
580 elog(NOTICE,
"ST_AsTWKB skipping NULL entry at position %d", i);
585 uid = DatumGetInt64(val_id);
595 idlist = palloc0(num_geoms *
sizeof(int64_t));
601 elog(ERROR,
"Geometries have different dimensionality");
602 PG_FREE_IF_COPY(arr_geoms, 0);
603 PG_FREE_IF_COPY(arr_ids, 1);
614 is_homogeneous =
false;
622 array_free_iterator(iter_geoms);
623 array_free_iterator(iter_ids);
627 elog(NOTICE,
"No valid geometry - id pairs found");
628 PG_FREE_IF_COPY(arr_geoms, 0);
629 PG_FREE_IF_COPY(arr_ids, 1);
632 if ( is_homogeneous )
641 if ( PG_NARGS() > 2 && ! PG_ARGISNULL(2) )
642 sp.precision_xy = PG_GETARG_INT32(2);
645 if ( PG_NARGS() > 3 && ! PG_ARGISNULL(3) )
646 sp.precision_z = PG_GETARG_INT32(3);
649 if ( PG_NARGS() > 4 && ! PG_ARGISNULL(4) )
650 sp.precision_m = PG_GETARG_INT32(4);
656 if ( PG_NARGS() > 5 && ! PG_ARGISNULL(5) && PG_GETARG_BOOL(5) )
660 if ( PG_NARGS() > 6 && ! PG_ARGISNULL(6) && PG_GETARG_BOOL(6) )
666 sp.precision_xy, sp.precision_z, sp.precision_m,
670 result = palloc(twkb_size + VARHDRSZ);
671 memcpy(VARDATA(result), twkb, twkb_size);
672 SET_VARSIZE(result, twkb_size + VARHDRSZ);
678 PG_FREE_IF_COPY(arr_geoms, 0);
679 PG_FREE_IF_COPY(arr_ids, 1);
681 PG_RETURN_BYTEA_P(result);
697 PG_FREE_IF_COPY(geom, 0);
698 PG_RETURN_POINTER(result);
709 PG_RETURN_POINTER(geom);
711 PG_RETURN_POINTER(gserialized_drop_gidx(geom));
718 elog(ERROR,
"%s",
string);
730 text *wkt_text = PG_GETARG_TEXT_P(0);
738 result = DirectFunctionCall1(
LWGEOM_in, CStringGetDatum(wkt));
744 PG_RETURN_DATUM(result);
758 StringInfo buf = (StringInfo) PG_GETARG_POINTER(0);
759 int32 geom_typmod = -1;
763 if ( (PG_NARGS()>2) && (!PG_ARGISNULL(2)) ) {
764 geom_typmod = PG_GETARG_INT32(2);
773 buf->cursor = buf->len;
778 if ( geom_typmod >= 0 )
781 POSTGIS_DEBUG(3,
"typmod and geometry were consistent");
785 POSTGIS_DEBUG(3,
"typmod was -1");
789 PG_RETURN_POINTER(geom);
797 POSTGIS_DEBUG(2,
"LWGEOM_send called");
810 POSTGIS_DEBUG(2,
"LWGEOM_to_bytea called");
825 POSTGIS_DEBUG(2,
"LWGEOM_from_bytea start");
827 result = (
GSERIALIZED *)DatumGetPointer(DirectFunctionCall1(
830 PG_RETURN_POINTER(result);
int32_t gserialized_get_srid(const GSERIALIZED *s)
Extract the SRID from the serialized form (it is packed into three bytes so this is a handy function)...
LWGEOM * lwgeom_from_gserialized(const GSERIALIZED *g)
Allocate a new LWGEOM from a GSERIALIZED.
int gserialized_has_bbox(const GSERIALIZED *gser)
Check if a GSERIALIZED has a bounding box without deserializing first.
uint32_t gserialized_get_type(const GSERIALIZED *s)
Extract the geometry type from the serialized form (it hides in the anonymous data area,...
GSERIALIZED * postgis_valid_typmod(GSERIALIZED *gser, int32_t typmod)
Check the consistency of the metadata we want to enforce in the typmod: srid, type and dimensionality...
#define LW_PARSER_CHECK_ALL
LWGEOM * lwcollection_as_lwgeom(const LWCOLLECTION *obj)
uint32_t lwtype_get_collectiontype(uint8_t type)
Given an lwtype number, what homogeneous collection can hold it?
int32_t lwgeom_get_srid(const LWGEOM *geom)
Return SRID number.
uint8_t * lwgeom_to_twkb_with_idlist(const LWGEOM *geom, int64_t *idlist, uint8_t variant, int8_t precision_xy, int8_t precision_z, int8_t precision_m, size_t *twkb_size)
Convert LWGEOM to a char* in TWKB format.
LWCOLLECTION * lwcollection_construct_empty(uint8_t type, int srid, char hasz, char hasm)
void lwgeom_free(LWGEOM *geom)
#define LW_PARSER_CHECK_NONE
LWGEOM * lwgeom_from_twkb(const uint8_t *twkb, size_t twkb_size, char check)
WKB inputs must have a declared size, to prevent malformed WKB from reading off the end of the memory...
void lwgeom_parser_result_init(LWGEOM_PARSER_RESULT *parser_result)
int lwgeom_parse_wkt(LWGEOM_PARSER_RESULT *parser_result, char *wktstr, int parse_flags)
Parse a WKT geometry string into an LWGEOM structure.
uint32_t lwgeom_get_type(const LWGEOM *geom)
Return LWTYPE number.
uint8_t * lwgeom_to_wkb(const LWGEOM *geom, uint8_t variant, size_t *size_out)
Convert LWGEOM to a char* in WKB format.
uint8_t * bytes_from_hexbytes(const char *hexbuf, size_t hexsize)
int lwgeom_needs_bbox(const LWGEOM *geom)
Check whether or not a lwgeom is big enough to warrant a bounding box.
int lwgeom_has_z(const LWGEOM *geom)
Return LW_TRUE if geometry has Z ordinates.
#define POINTTYPE
LWTYPE numbers, used internally by PostGIS.
char * lwgeom_to_hexwkb(const LWGEOM *geom, uint8_t variant, size_t *size_out)
char * lwpoint_to_latlon(const LWPOINT *p, const char *format)
const char * lwtype_name(uint8_t type)
Return the type name string associated with a type number (e.g.
void lwcollection_free(LWCOLLECTION *col)
#define TWKB_DEFAULT_PRECISION
LWCOLLECTION * lwcollection_add_lwgeom(LWCOLLECTION *col, const LWGEOM *geom)
Appends geom to the collection managed by col.
LWGEOM * lwgeom_from_wkb(const uint8_t *wkb, const size_t wkb_size, const char check)
WKB inputs must have a declared size, to prevent malformed WKB from reading off the end of the memory...
int lwgeom_has_m(const LWGEOM *geom)
Return LW_TRUE if geometry has M ordinates.
void lwgeom_set_srid(LWGEOM *geom, int srid)
Set the SRID on an LWGEOM For collections, only the parent gets an SRID, all the children get SRID_UN...
void lwgeom_add_bbox(LWGEOM *lwgeom)
Compute a bbox if not already computed.
void lwgeom_parser_result_free(LWGEOM_PARSER_RESULT *parser_result)
uint8_t * lwgeom_to_twkb(const LWGEOM *geom, uint8_t variant, int8_t precision_xy, int8_t precision_z, int8_t precision_m, size_t *twkb_size)
This library is the generic geometry handling section of PostGIS.
Datum WKBFromLWGEOM(PG_FUNCTION_ARGS)
Datum parse_WKT_lwgeom(PG_FUNCTION_ARGS)
Datum TWKBFromLWGEOM(PG_FUNCTION_ARGS)
PG_FUNCTION_INFO_V1(LWGEOM_in)
Datum LWGEOM_in(PG_FUNCTION_ARGS)
Datum LWGEOM_to_latlon(PG_FUNCTION_ARGS)
Datum LWGEOM_out(PG_FUNCTION_ARGS)
Datum LWGEOM_to_bytea(PG_FUNCTION_ARGS)
Datum LWGEOMFromTWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_from_bytea(PG_FUNCTION_ARGS)
Datum TWKBFromLWGEOMArray(PG_FUNCTION_ARGS)
Datum LWGEOM_send(PG_FUNCTION_ARGS)
Datum LWGEOM_dropBBOX(PG_FUNCTION_ARGS)
Datum LWGEOM_to_text(PG_FUNCTION_ARGS)
Datum LWGEOMFromEWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_addBBOX(PG_FUNCTION_ARGS)
void elog_ERROR(const char *string)
Datum LWGEOM_asHEXEWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_recv(PG_FUNCTION_ARGS)
char * text_to_cstring(const text *textptr)
GSERIALIZED * geometry_serialize(LWGEOM *lwgeom)
Parser result structure: returns the result of attempting to convert (E)WKT/(E)WKB to LWGEOM.