Changeset 2616 for trunk/lwgeom/lwpostgis.sql.in
- Timestamp:
- 06/04/07 16:06:28 (5 years ago)
- Files:
-
- 1 modified
-
trunk/lwgeom/lwpostgis.sql.in (modified) (314 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/lwgeom/lwpostgis.sql.in
r2609 r2616 36 36 #endif 37 37 38 -- Deprecation in 1.2.3 38 39 CREATEFUNCTION histogram2d_in(HISTOGRAM_OUT_REP) 39 40 RETURNS HISTOGRAM_IN_REP … … 41 42 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 42 43 44 -- Availability: 1.2.2 45 CREATEFUNCTION ST_histogram2d_in(HISTOGRAM_OUT_REP) 46 RETURNS HISTOGRAM_IN_REP 47 AS '@MODULE_FILENAME@', 'lwhistogram2d_in' 48 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 49 50 -- Deprecation in 1.2.3 43 51 CREATEFUNCTION histogram2d_out(HISTOGRAM_IN_REP) 44 52 RETURNS HISTOGRAM_OUT_REP … … 46 54 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 47 55 56 -- Availability: 1.2.2 57 CREATEFUNCTION ST_histogram2d_out(HISTOGRAM_IN_REP) 58 RETURNS HISTOGRAM_OUT_REP 59 AS '@MODULE_FILENAME@', 'lwhistogram2d_out' 60 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 61 48 62 CREATE TYPE histogram2d ( 49 63 alignment = double, 50 64 internallength = variable, 51 input = histogram2d_in,52 output = histogram2d_out,65 input = ST_histogram2d_in, 66 output = ST_histogram2d_out, 53 67 storage = main 54 68 ); … … 66 80 #endif 67 81 82 -- Deprecation in 1.2.3 68 83 CREATEFUNCTION spheroid_in(SPHEROID_OUT_REP) 69 84 RETURNS SPHEROID_IN_REP … … 71 86 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 72 87 88 -- Availability: 1.2.2 89 CREATEFUNCTION ST_spheroid_in(SPHEROID_OUT_REP) 90 RETURNS SPHEROID_IN_REP 91 AS '@MODULE_FILENAME@','ellipsoid_in' 92 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 93 94 -- Deprecation in 1.2.3 73 95 CREATEFUNCTION spheroid_out(SPHEROID_IN_REP) 74 96 RETURNS SPHEROID_OUT_REP … … 76 98 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 77 99 100 -- Availability: 1.2.2 101 CREATEFUNCTION ST_spheroid_out(SPHEROID_IN_REP) 102 RETURNS SPHEROID_OUT_REP 103 AS '@MODULE_FILENAME@','ellipsoid_out' 104 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 105 78 106 CREATE TYPE spheroid ( 79 107 alignment = double, 80 108 internallength = 65, 81 input = spheroid_in,82 output = spheroid_out109 input = ST_spheroid_in, 110 output = ST_spheroid_out 83 111 ); 84 112 … … 95 123 #endif 96 124 125 -- Deprecation in 1.2.3 97 126 CREATEFUNCTION geometry_in(GEOMETRY_OUT_REP) 98 127 RETURNS geometry … … 100 129 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 101 130 131 -- Availability: 1.2.2 132 CREATEFUNCTION ST_geometry_in(GEOMETRY_OUT_REP) 133 RETURNS geometry 134 AS '@MODULE_FILENAME@','LWGEOM_in' 135 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 136 137 -- Deprecation in 1.2.3 102 138 CREATEFUNCTION geometry_out(GEOMETRY_IN_REP) 103 139 RETURNS cstring … … 105 141 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 106 142 143 -- Availability: 1.2.2 144 CREATEFUNCTION ST_geometry_out(GEOMETRY_IN_REP) 145 RETURNS cstring 146 AS '@MODULE_FILENAME@','LWGEOM_out' 147 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 148 107 149 #if USE_VERSION >= 80 150 -- Deprecation in 1.2.3 108 151 CREATEFUNCTION geometry_analyze(internal) 109 152 RETURNS bool 110 153 AS '@MODULE_FILENAME@', 'LWGEOM_analyze' 111 154 LANGUAGE 'C' _VOLATILE_STRICT; -- WITH (isstrict); 155 156 -- Availability: 1.2.2 157 CREATEFUNCTION ST_geometry_analyze(internal) 158 RETURNS bool 159 AS '@MODULE_FILENAME@', 'LWGEOM_analyze' 160 LANGUAGE 'C' _VOLATILE_STRICT; -- WITH (isstrict); 112 161 #endif 113 162 114 163 #if USE_VERSION > 73 164 -- Deprecation in 1.2.3 115 165 CREATEFUNCTION geometry_recv(internal) 116 166 RETURNS geometry … … 118 168 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 119 169 170 -- Availability: 1.2.2 171 CREATEFUNCTION ST_geometry_recv(internal) 172 RETURNS geometry 173 AS '@MODULE_FILENAME@','LWGEOM_recv' 174 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 175 176 -- Deprecation in 1.2.3 120 177 CREATEFUNCTION geometry_send(geometry) 121 178 RETURNS bytea 122 179 AS '@MODULE_FILENAME@','LWGEOM_send' 123 180 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 181 182 -- Availability: 1.2.2 183 CREATEFUNCTION ST_geometry_send(geometry) 184 RETURNS bytea 185 AS '@MODULE_FILENAME@','LWGEOM_send' 186 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 124 187 #endif 125 126 188 127 189 CREATE TYPE geometry ( 128 190 internallength = variable, 129 input = geometry_in,130 output = geometry_out,191 input = ST_geometry_in, 192 output = ST_geometry_out, 131 193 #if USE_VERSION > 73 132 send = geometry_send,133 receive = geometry_recv,194 send = ST_geometry_send, 195 receive = ST_geometry_recv, 134 196 #endif 135 197 delimiter = ':', 136 198 #if USE_VERSION >= 80 137 analyze = geometry_analyze,199 analyze = ST_geometry_analyze, 138 200 #endif 139 201 storage = main … … 145 207 146 208 -- Availability: 1.1.2 209 -- Deprecation in 1.2.3 147 210 CREATE OR REPLACE FUNCTION Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8) 148 211 RETURNS geometry … … 150 213 LANGUAGE 'C' _IMMUTABLE_STRICT; 151 214 215 -- Availability: 1.2.2 216 CREATE OR REPLACE FUNCTION ST_Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8) 217 RETURNS geometry 218 AS '@MODULE_FILENAME@', 'LWGEOM_affine' 219 LANGUAGE 'C' _IMMUTABLE_STRICT; 220 152 221 -- Availability: 1.1.2 222 -- Deprecation in 1.2.3 153 223 CREATE OR REPLACE FUNCTION Affine(geometry,float8,float8,float8,float8,float8,float8) 154 224 RETURNS geometry … … 156 226 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 157 227 228 -- Availability: 1.2.2 229 CREATE OR REPLACE FUNCTION ST_Affine(geometry,float8,float8,float8,float8,float8,float8) 230 RETURNS geometry 231 AS 'SELECT affine($1, $2, $3, 0, $4, $5, 0, 0, 0, 1, $6, $7, 0)' 232 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 233 158 234 -- Availability: 1.1.2 235 -- Deprecation in 1.2.3 159 236 CREATEFUNCTION RotateZ(geometry,float8) 160 237 RETURNS geometry … … 162 239 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 163 240 241 -- Availability: 1.2.2 242 CREATEFUNCTION ST_RotateZ(geometry,float8) 243 RETURNS geometry 244 AS 'SELECT affine($1, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0, 1, 0, 0, 0)' 245 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 246 164 247 -- Availability: 1.1.2 248 -- Deprecation in 1.2.3 165 249 CREATEFUNCTION Rotate(geometry,float8) 166 250 RETURNS geometry … … 168 252 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 169 253 254 -- Availability: 1.2.2 255 CREATEFUNCTION ST_Rotate(geometry,float8) 256 RETURNS geometry 257 AS 'SELECT rotateZ($1, $2)' 258 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 259 170 260 -- Availability: 1.1.2 261 -- Deprecation in 1.2.3 171 262 CREATEFUNCTION RotateX(geometry,float8) 172 263 RETURNS geometry … … 174 265 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 175 266 267 -- Availability: 1.2.2 268 CREATEFUNCTION ST_RotateX(geometry,float8) 269 RETURNS geometry 270 AS 'SELECT affine($1, 1, 0, 0, 0, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0)' 271 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 272 176 273 -- Availability: 1.1.2 274 -- Deprecation in 1.2.3 177 275 CREATEFUNCTION RotateY(geometry,float8) 178 276 RETURNS geometry … … 180 278 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 181 279 280 -- Availability: 1.2.2 281 CREATEFUNCTION ST_RotateY(geometry,float8) 282 RETURNS geometry 283 AS 'SELECT affine($1, cos($2), 0, sin($2), 0, 1, 0, -sin($2), 0, cos($2), 0, 0, 0)' 284 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 285 286 -- Deprecation in 1.2.3 182 287 CREATEFUNCTION Translate(geometry,float8,float8,float8) 183 288 RETURNS geometry … … 185 290 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 186 291 292 -- Availability: 1.2.2 293 CREATEFUNCTION ST_Translate(geometry,float8,float8,float8) 294 RETURNS geometry 295 AS 'SELECT affine($1, 1, 0, 0, 0, 1, 0, 0, 0, 1, $2, $3, $4)' 296 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 297 298 -- Deprecation in 1.2.3 187 299 CREATEFUNCTION Translate(geometry,float8,float8) 188 300 RETURNS geometry … … 190 302 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 191 303 304 -- Availability: 1.2.2 305 CREATEFUNCTION ST_Translate(geometry,float8,float8) 306 RETURNS geometry 307 AS 'SELECT translate($1, $2, $3, 0)' 308 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 309 192 310 -- Availability: 1.1.0 311 -- Deprecation in 1.2.3 193 312 CREATEFUNCTION Scale(geometry,float8,float8,float8) 194 313 RETURNS geometry … … 196 315 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 197 316 317 -- Availability: 1.2.2 318 CREATEFUNCTION ST_Scale(geometry,float8,float8,float8) 319 RETURNS geometry 320 AS 'SELECT affine($1, $2, 0, 0, 0, $3, 0, 0, 0, $4, 0, 0, 0)' 321 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 322 198 323 -- Availability: 1.1.0 324 -- Deprecation in 1.2.3 199 325 CREATEFUNCTION Scale(geometry,float8,float8) 200 326 RETURNS geometry … … 202 328 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 203 329 330 -- Availability: 1.2.2 331 CREATEFUNCTION ST_Scale(geometry,float8,float8) 332 RETURNS geometry 333 AS 'SELECT scale($1, $2, $3, 1)' 334 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 335 204 336 -- Availability: 1.1.0 337 -- Deprecation in 1.2.3 205 338 CREATEFUNCTION transscale(geometry,float8,float8,float8,float8) 206 339 RETURNS geometry … … 209 342 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 210 343 344 -- Availability: 1.2.2 345 CREATEFUNCTION ST_transscale(geometry,float8,float8,float8,float8) 346 RETURNS geometry 347 AS 'SELECT affine($1, $4, 0, 0, 0, $5, 0, 348 0, 0, 1, $2 * $4, $3 * $5, 0)' 349 LANGUAGE 'SQL' _IMMUTABLE_STRICT; 350 211 351 -- Availability: 1.1.0 352 -- Deprecation in 1.2.3 212 353 CREATEFUNCTION shift_longitude(geometry) 213 354 RETURNS geometry … … 215 356 LANGUAGE 'C' _IMMUTABLE_STRICT; 216 357 217 218 358 -- Availability: 1.2.2 359 CREATEFUNCTION ST_shift_longitude(geometry) 360 RETURNS geometry 361 AS '@MODULE_FILENAME@', 'LWGEOM_longitude_shift' 362 LANGUAGE 'C' _IMMUTABLE_STRICT; 363 219 364 ------------------------------------------------------------------- 220 365 -- BOX3D TYPE … … 229 374 #endif 230 375 376 -- Deprecation in 1.2.3 231 377 CREATEFUNCTION box3d_in(BOX3D_OUT_REP) 232 378 RETURNS BOX3D_IN_REP … … 234 380 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 235 381 382 -- Deprecation in 1.2.3 236 383 CREATEFUNCTION box3d_out(BOX3D_IN_REP) 237 384 RETURNS BOX3D_OUT_REP … … 239 386 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 240 387 388 -- Availability: 1.2.2 389 CREATEFUNCTION ST_box3d_in(BOX3D_OUT_REP) 390 RETURNS BOX3D_IN_REP 391 AS '@MODULE_FILENAME@', 'BOX3D_in' 392 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 393 394 -- Availability: 1.2.2 395 CREATEFUNCTION ST_box3d_out(BOX3D_IN_REP) 396 RETURNS BOX3D_OUT_REP 397 AS '@MODULE_FILENAME@', 'BOX3D_out' 398 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 399 241 400 CREATE TYPE box3d ( 242 401 alignment = double, 243 402 internallength = 48, 244 input = box3d_in,245 output = box3d_out403 input = ST_box3d_in, 404 output = ST_box3d_out 246 405 ); 247 406 407 -- Deprecation in 1.2.3 248 408 CREATEFUNCTION xmin(box3d) 249 409 RETURNS FLOAT8 … … 251 411 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 252 412 413 -- Availability: 1.2.2 414 CREATEFUNCTION ST_xmin(box3d) 415 RETURNS FLOAT8 416 AS '@MODULE_FILENAME@','BOX3D_xmin' 417 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 418 419 -- Deprecation in 1.2.3 253 420 CREATEFUNCTION ymin(box3d) 254 421 RETURNS FLOAT8 … … 256 423 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 257 424 425 -- Availability: 1.2.2 426 CREATEFUNCTION ST_ymin(box3d) 427 RETURNS FLOAT8 428 AS '@MODULE_FILENAME@','BOX3D_ymin' 429 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 430 431 -- Deprecation in 1.2.3 258 432 CREATEFUNCTION zmin(box3d) 259 433 RETURNS FLOAT8 … … 261 435 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 262 436 437 -- Availability: 1.2.2 438 CREATEFUNCTION ST_zmin(box3d) 439 RETURNS FLOAT8 440 AS '@MODULE_FILENAME@','BOX3D_zmin' 441 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 442 443 -- Deprecation in 1.2.3 263 444 CREATEFUNCTION xmax(box3d) 264 445 RETURNS FLOAT8 … … 266 447 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 267 448 449 -- Availability: 1.2.2 450 CREATEFUNCTION ST_xmax(box3d) 451 RETURNS FLOAT8 452 AS '@MODULE_FILENAME@','BOX3D_xmax' 453 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 454 455 -- Deprecation in 1.2.3 268 456 CREATEFUNCTION ymax(box3d) 269 457 RETURNS FLOAT8 … … 271 459 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 272 460 461 -- Availability: 1.2.2 462 CREATEFUNCTION ST_ymax(box3d) 463 RETURNS FLOAT8 464 AS '@MODULE_FILENAME@','BOX3D_ymax' 465 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 466 467 -- Deprecation in 1.2.3 273 468 CREATEFUNCTION zmax(box3d) 469 RETURNS FLOAT8 470 AS '@MODULE_FILENAME@','BOX3D_zmax' 471 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 472 473 -- Availability: 1.2.2 474 CREATEFUNCTION ST_zmax(box3d) 274 475 RETURNS FLOAT8 275 476 AS '@MODULE_FILENAME@','BOX3D_zmax' … … 288 489 #endif 289 490 491 -- Deprecation in 1.2.3 290 492 CREATEFUNCTION chip_in(CHIP_OUT_REP) 291 493 RETURNS CHIP_IN_REP 292 494 AS '@MODULE_FILENAME@','CHIP_in' 293 495 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 294 496 497 -- Availability: 1.2.2 498 CREATEFUNCTION ST_chip_in(CHIP_OUT_REP) 499 RETURNS CHIP_IN_REP 500 AS '@MODULE_FILENAME@','CHIP_in' 501 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 502 503 -- Deprecation in 1.2.3 295 504 CREATEFUNCTION chip_out(CHIP_IN_REP) 296 505 RETURNS CHIP_OUT_REP … … 298 507 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 299 508 509 -- Availability: 1.2.2 510 CREATEFUNCTION ST_chip_out(CHIP_IN_REP) 511 RETURNS CHIP_OUT_REP 512 AS '@MODULE_FILENAME@','CHIP_out' 513 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 514 300 515 CREATE TYPE chip ( 301 516 alignment = double, 302 517 internallength = variable, 303 input = chip_in,304 output = chip_out,518 input = ST_chip_in, 519 output = ST_chip_out, 305 520 storage = extended 306 521 ); … … 319 534 #endif 320 535 536 -- Deprecation in 1.2.3 321 537 CREATEFUNCTION box2d_in(BOX2D_OUT_REP) 322 538 RETURNS box2d … … 324 540 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 325 541 542 -- Availability: 1.2.2 543 CREATEFUNCTION ST_box2d_in(BOX2D_OUT_REP) 544 RETURNS box2d 545 AS '@MODULE_FILENAME@','BOX2DFLOAT4_in' 546 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 547 548 -- Deprecation in 1.2.3 326 549 CREATEFUNCTION box2d_out(BOX2D_IN_REP) 327 550 RETURNS cstring … … 329 552 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 330 553 554 -- Availability: 1.2.2 555 CREATEFUNCTION ST_box2d_out(BOX2D_IN_REP) 556 RETURNS cstring 557 AS '@MODULE_FILENAME@','BOX2DFLOAT4_out' 558 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 559 331 560 CREATE TYPE box2d ( 332 561 internallength = 16, 333 input = box2d_in,334 output = box2d_out,562 input = ST_box2d_in, 563 output = ST_box2d_out, 335 564 storage = plain 336 565 ); … … 338 567 ---- BOX2D support functions 339 568 340 569 -- Deprecation in 1.2.3 341 570 CREATEFUNCTION box2d_overleft(box2d, box2d) 342 571 RETURNS bool … … 344 573 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 345 574 575 -- Availability: 1.2.2 576 CREATEFUNCTION ST_box2d_overleft(box2d, box2d) 577 RETURNS bool 578 AS '@MODULE_FILENAME@', 'BOX2D_overleft' 579 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 580 581 -- Deprecation in 1.2.3 346 582 CREATEFUNCTION box2d_overright(box2d, box2d) 347 583 RETURNS bool … … 349 585 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 350 586 587 -- Availability: 1.2.2 588 CREATEFUNCTION ST_box2d_overright(box2d, box2d) 589 RETURNS bool 590 AS '@MODULE_FILENAME@', 'BOX2D_overright' 591 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 592 593 -- Deprecation in 1.2.3 351 594 CREATEFUNCTION box2d_left(box2d, box2d) 352 595 RETURNS bool … … 354 597 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 355 598 599 -- Availability: 1.2.2 600 CREATEFUNCTION ST_box2d_left(box2d, box2d) 601 RETURNS bool 602 AS '@MODULE_FILENAME@', 'BOX2D_left' 603 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 604 605 -- Deprecation in 1.2.3 356 606 CREATEFUNCTION box2d_right(box2d, box2d) 357 607 RETURNS bool … … 359 609 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 360 610 611 -- Availability: 1.2.2 612 CREATEFUNCTION ST_box2d_right(box2d, box2d) 613 RETURNS bool 614 AS '@MODULE_FILENAME@', 'BOX2D_right' 615 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 616 617 -- Deprecation in 1.2.3 361 618 CREATEFUNCTION box2d_contain(box2d, box2d) 362 619 RETURNS bool … … 364 621 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 365 622 623 -- Availability: 1.2.2 624 CREATEFUNCTION ST_box2d_contain(box2d, box2d) 625 RETURNS bool 626 AS '@MODULE_FILENAME@', 'BOX2D_contain' 627 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 628 629 -- Deprecation in 1.2.3 366 630 CREATEFUNCTION box2d_contained(box2d, box2d) 367 631 RETURNS bool … … 369 633 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 370 634 635 -- Availability: 1.2.2 636 CREATEFUNCTION ST_box2d_contained(box2d, box2d) 637 RETURNS bool 638 AS '@MODULE_FILENAME@', 'BOX2D_contained' 639 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 640 641 -- Deprecation in 1.2.3 371 642 CREATEFUNCTION box2d_overlap(box2d, box2d) 372 643 RETURNS bool … … 374 645 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 375 646 647 -- Availability: 1.2.2 648 CREATEFUNCTION ST_box2d_overlap(box2d, box2d) 649 RETURNS bool 650 AS '@MODULE_FILENAME@', 'BOX2D_overlap' 651 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 652 653 -- Deprecation in 1.2.3 376 654 CREATEFUNCTION box2d_same(box2d, box2d) 377 655 RETURNS bool … … 379 657 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 380 658 659 -- Availability: 1.2.2 660 CREATEFUNCTION ST_box2d_same(box2d, box2d) 661 RETURNS bool 662 AS '@MODULE_FILENAME@', 'BOX2D_same' 663 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 664 665 -- Deprecation in 1.2.3 381 666 CREATEFUNCTION box2d_intersects(box2d, box2d) 382 667 RETURNS bool … … 384 669 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 385 670 671 -- Availability: 1.2.2 672 CREATEFUNCTION ST_box2d_intersects(box2d, box2d) 673 RETURNS bool 674 AS '@MODULE_FILENAME@', 'BOX2D_intersects' 675 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 676 677 386 678 -- lwgeom operator support functions 387 679 … … 390 682 ------------------------------------------------------------------- 391 683 684 -- Deprecation in 1.2.3 392 685 CREATEFUNCTION geometry_lt(geometry, geometry) 393 686 RETURNS bool … … 395 688 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 396 689 690 -- Availability: 1.2.2 691 CREATEFUNCTION ST_geometry_lt(geometry, geometry) 692 RETURNS bool 693 AS '@MODULE_FILENAME@', 'lwgeom_lt' 694 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 695 696 -- Deprecation in 1.2.3 397 697 CREATEFUNCTION geometry_le(geometry, geometry) 398 698 RETURNS bool … … 400 700 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 401 701 702 -- Availability: 1.2.2 703 CREATEFUNCTION ST_geometry_le(geometry, geometry) 704 RETURNS bool 705 AS '@MODULE_FILENAME@', 'lwgeom_le' 706 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 707 708 -- Deprecation in 1.2.3 402 709 CREATEFUNCTION geometry_gt(geometry, geometry) 403 710 RETURNS bool … … 405 712 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 406 713 714 -- Availability: 1.2.2 715 CREATEFUNCTION ST_geometry_gt(geometry, geometry) 716 RETURNS bool 717 AS '@MODULE_FILENAME@', 'lwgeom_gt' 718 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 719 720 -- Deprecation in 1.2.3 407 721 CREATEFUNCTION geometry_ge(geometry, geometry) 408 722 RETURNS bool … … 410 724 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 411 725 726 -- Availability: 1.2.2 727 CREATEFUNCTION ST_geometry_ge(geometry, geometry) 728 RETURNS bool 729 AS '@MODULE_FILENAME@', 'lwgeom_ge' 730 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 731 732 -- Deprecation in 1.2.3 412 733 CREATEFUNCTION geometry_eq(geometry, geometry) 413 734 RETURNS bool … … 415 736 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 416 737 738 -- Availability: 1.2.2 739 CREATEFUNCTION ST_geometry_eq(geometry, geometry) 740 RETURNS bool 741 AS '@MODULE_FILENAME@', 'lwgeom_eq' 742 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 743 744 -- Deprecation in 1.2.3 417 745 CREATEFUNCTION geometry_cmp(geometry, geometry) 418 746 RETURNS integer … … 420 748 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 421 749 750 -- Availability: 1.2.2 751 CREATEFUNCTION ST_geometry_cmp(geometry, geometry) 752 RETURNS integer 753 AS '@MODULE_FILENAME@', 'lwgeom_cmp' 754 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 755 422 756 -- 423 757 -- Sorting operators for Btree … … 425 759 426 760 CREATE OPERATOR < ( 427 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_lt,761 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_lt, 428 762 COMMUTATOR = '>', NEGATOR = '>=', 429 763 RESTRICT = contsel, JOIN = contjoinsel … … 431 765 432 766 CREATE OPERATOR <= ( 433 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_le,767 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_le, 434 768 COMMUTATOR = '>=', NEGATOR = '>', 435 769 RESTRICT = contsel, JOIN = contjoinsel … … 437 771 438 772 CREATE OPERATOR = ( 439 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_eq,773 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_eq, 440 774 COMMUTATOR = '=', -- we might implement a faster negator here 441 775 RESTRICT = contsel, JOIN = contjoinsel … … 443 777 444 778 CREATE OPERATOR >= ( 445 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_ge,779 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_ge, 446 780 COMMUTATOR = '<=', NEGATOR = '<', 447 781 RESTRICT = contsel, JOIN = contjoinsel 448 782 ); 449 783 CREATE OPERATOR > ( 450 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_gt,784 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_gt, 451 785 COMMUTATOR = '<', NEGATOR = '<=', 452 786 RESTRICT = contsel, JOIN = contjoinsel … … 470 804 -- GiST indexes 471 805 ------------------------------------------------------------------- 806 -- Deprecation in 1.2.3 472 807 #if USE_VERSION < 73 473 808 CREATEFUNCTION postgis_gist_sel(opaque, oid, opaque, int4) … … 479 814 LANGUAGE 'C'; 480 815 816 -- Availability: 1.2.2 817 #if USE_VERSION < 73 818 CREATEFUNCTION ST_postgis_gist_sel(opaque, oid, opaque, int4) 819 #else 820 CREATEFUNCTION ST_postgis_gist_sel (internal, oid, internal, int4) 821 #endif 822 RETURNS float8 823 AS '@MODULE_FILENAME@', 'LWGEOM_gist_sel' 824 LANGUAGE 'C'; 825 826 -- Deprecation in 1.2.3 481 827 #if USE_VERSION == 72 482 828 CREATEFUNCTION postgis_gist_joinsel(opaque, oid, opaque) … … 490 836 LANGUAGE 'C'; 491 837 838 -- Availability: 1.2.2 839 #if USE_VERSION == 72 840 CREATEFUNCTION ST_postgis_gist_joinsel(opaque, oid, opaque) 841 #elif USE_VERSION == 73 842 CREATEFUNCTION ST_postgis_gist_joinsel(internal, oid, internal) 843 #else 844 CREATEFUNCTION ST_postgis_gist_joinsel(internal, oid, internal, smallint) 845 #endif 846 RETURNS float8 847 AS '@MODULE_FILENAME@', 'LWGEOM_gist_joinsel' 848 LANGUAGE 'C'; 849 850 -- Deprecation in 1.2.3 492 851 CREATEFUNCTION geometry_overleft(geometry, geometry) 493 852 RETURNS bool … … 495 854 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 496 855 856 -- Availability: 1.2.2 857 CREATEFUNCTION ST_geometry_overleft(geometry, geometry) 858 RETURNS bool 859 AS '@MODULE_FILENAME@', 'LWGEOM_overleft' 860 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 861 862 -- Deprecation in 1.2.3 497 863 CREATEFUNCTION geometry_overright(geometry, geometry) 498 864 RETURNS bool … … 500 866 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 501 867 868 -- Availability: 1.2.2 869 CREATEFUNCTION ST_geometry_overright(geometry, geometry) 870 RETURNS bool 871 AS '@MODULE_FILENAME@', 'LWGEOM_overright' 872 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 873 874 -- Deprecation in 1.2.3 502 875 CREATEFUNCTION geometry_overabove(geometry, geometry) 503 876 RETURNS bool … … 505 878 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 506 879 880 -- Availability: 1.2.2 881 CREATEFUNCTION ST_geometry_overabove(geometry, geometry) 882 RETURNS bool 883 AS '@MODULE_FILENAME@', 'LWGEOM_overabove' 884 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 885 886 -- Deprecation in 1.2.3 507 887 CREATEFUNCTION geometry_overbelow(geometry, geometry) 508 888 RETURNS bool … … 510 890 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 511 891 892 -- Availability: 1.2.2 893 CREATEFUNCTION ST_geometry_overbelow(geometry, geometry) 894 RETURNS bool 895 AS '@MODULE_FILENAME@', 'LWGEOM_overbelow' 896 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 897 898 -- Deprecation in 1.2.3 512 899 CREATEFUNCTION geometry_left(geometry, geometry) 513 900 RETURNS bool … … 515 902 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 516 903 904 -- Availability: 1.2.2 905 CREATEFUNCTION ST_geometry_left(geometry, geometry) 906 RETURNS bool 907 AS '@MODULE_FILENAME@', 'LWGEOM_left' 908 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 909 910 -- Deprecation in 1.2.3 517 911 CREATEFUNCTION geometry_right(geometry, geometry) 518 912 RETURNS bool … … 520 914 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 521 915 916 -- Availability: 1.2.2 917 CREATEFUNCTION ST_geometry_right(geometry, geometry) 918 RETURNS bool 919 AS '@MODULE_FILENAME@', 'LWGEOM_right' 920 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 921 922 -- Deprecation in 1.2.3 522 923 CREATEFUNCTION geometry_above(geometry, geometry) 523 924 RETURNS bool … … 525 926 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 526 927 928 -- Availability: 1.2.2 929 CREATEFUNCTION ST_geometry_above(geometry, geometry) 930 RETURNS bool 931 AS '@MODULE_FILENAME@', 'LWGEOM_above' 932 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 933 934 -- Deprecation in 1.2.3 527 935 CREATEFUNCTION geometry_below(geometry, geometry) 528 936 RETURNS bool … … 530 938 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 531 939 940 -- Availability: 1.2.2 941 CREATEFUNCTION ST_geometry_below(geometry, geometry) 942 RETURNS bool 943 AS '@MODULE_FILENAME@', 'LWGEOM_below' 944 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 945 946 -- Deprecation in 1.2.3 532 947 CREATEFUNCTION geometry_contain(geometry, geometry) 533 948 RETURNS bool … … 535 950 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 536 951 952 -- Availability: 1.2.2 953 CREATEFUNCTION ST_geometry_contain(geometry, geometry) 954 RETURNS bool 955 AS '@MODULE_FILENAME@', 'LWGEOM_contain' 956 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 957 958 -- Deprecation in 1.2.3 537 959 CREATEFUNCTION geometry_contained(geometry, geometry) 538 960 RETURNS bool … … 540 962 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 541 963 964 -- Availability: 1.2.2 965 CREATEFUNCTION ST_geometry_contained(geometry, geometry) 966 RETURNS bool 967 AS '@MODULE_FILENAME@', 'LWGEOM_contained' 968 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 969 970 -- Deprecation in 1.2.3 542 971 CREATEFUNCTION geometry_overlap(geometry, geometry) 543 972 RETURNS bool … … 545 974 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 546 975 976 -- Availability: 1.2.2 977 CREATEFUNCTION ST_geometry_overlap(geometry, geometry) 978 RETURNS bool 979 AS '@MODULE_FILENAME@', 'LWGEOM_overlap' 980 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 981 982 -- Deprecation in 1.2.3 547 983 CREATEFUNCTION geometry_same(geometry, geometry) 548 984 RETURNS bool … … 550 986 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 551 987 988 --Availability: 1.2.2 989 CREATEFUNCTION ST_geometry_same(geometry, geometry) 990 RETURNS bool 991 AS '@MODULE_FILENAME@', 'LWGEOM_same' 992 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 993 552 994 -- GEOMETRY operators 553 995 554 996 CREATE OPERATOR << ( 555 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_left,997 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_left, 556 998 COMMUTATOR = '>>', 557 999 RESTRICT = positionsel, JOIN = positionjoinsel … … 559 1001 560 1002 CREATE OPERATOR &< ( 561 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overleft,1003 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_overleft, 562 1004 COMMUTATOR = '&>', 563 1005 RESTRICT = positionsel, JOIN = positionjoinsel … … 565 1007 566 1008 CREATE OPERATOR <<| ( 567 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_below,1009 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_below, 568 1010 COMMUTATOR = '|>>', 569 1011 RESTRICT = positionsel, JOIN = positionjoinsel … … 571 1013 572 1014 CREATE OPERATOR &<| ( 573 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overbelow,1015 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_overbelow, 574 1016 COMMUTATOR = '|&>', 575 1017 RESTRICT = positionsel, JOIN = positionjoinsel … … 577 1019 578 1020 CREATE OPERATOR && ( 579 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overlap,1021 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_overlap, 580 1022 COMMUTATOR = '&&', 581 RESTRICT = postgis_gist_sel, JOIN =postgis_gist_joinsel1023 RESTRICT = ST_postgis_gist_sel, JOIN = ST_postgis_gist_joinsel 582 1024 ); 583 1025 584 1026 CREATE OPERATOR &> ( 585 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overright,1027 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_overright, 586 1028 COMMUTATOR = '&<', 587 1029 RESTRICT = positionsel, JOIN = positionjoinsel … … 589 1031 590 1032 CREATE OPERATOR >> ( 591 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_right,1033 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_right, 592 1034 COMMUTATOR = '<<', 593 1035 RESTRICT = positionsel, JOIN = positionjoinsel … … 595 1037 596 1038 CREATE OPERATOR |&> ( 597 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overabove,1039 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_overabove, 598 1040 COMMUTATOR = '&<|', 599 1041 RESTRICT = positionsel, JOIN = positionjoinsel … … 601 1043 602 1044 CREATE OPERATOR |>> ( 603 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_above,1045 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_above, 604 1046 COMMUTATOR = '<<|', 605 1047 RESTRICT = positionsel, JOIN = positionjoinsel … … 607 1049 608 1050 CREATE OPERATOR ~= ( 609 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_same,1051 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_same, 610 1052 COMMUTATOR = '~=', 611 1053 RESTRICT = eqsel, JOIN = eqjoinsel … … 613 1055 614 1056 CREATE OPERATOR @ ( 615 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_contained,1057 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_contained, 616 1058 COMMUTATOR = '~', 617 1059 RESTRICT = contsel, JOIN = contjoinsel … … 619 1061 620 1062 CREATE OPERATOR ~ ( 621 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_contain,1063 LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = ST_geometry_contain, 622 1064 COMMUTATOR = '@', 623 1065 RESTRICT = contsel, JOIN = contjoinsel … … 907 1349 ------------------------------------------- 908 1350 1351 -- Deprecation in 1.2.3 909 1352 CREATEFUNCTION addBBOX(geometry) 910 1353 RETURNS geometry … … 912 1355 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 913 1356 1357 -- Availability: 1.2.2 1358 CREATEFUNCTION ST_addBBOX(geometry) 1359 RETURNS geometry 1360 AS '@MODULE_FILENAME@','LWGEOM_addBBOX' 1361 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1362 1363 -- Deprecation in 1.2.3 914 1364 CREATEFUNCTION dropBBOX(geometry) 915 1365 RETURNS geometry … … 917 1367 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 918 1368 1369 -- Availability: 1.2.2 1370 CREATEFUNCTION ST_dropBBOX(geometry) 1371 RETURNS geometry 1372 AS '@MODULE_FILENAME@','LWGEOM_dropBBOX' 1373 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 919 1374 1375 -- Deprecation in 1.2.3 920 1376 CREATEFUNCTION getSRID(geometry) 921 1377 RETURNS int4 … … 923 1379 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 924 1380 1381 -- Availability: 1.2.2 1382 CREATEFUNCTION getSRID(geometry) 1383 RETURNS int4 1384 AS '@MODULE_FILENAME@','LWGEOM_getSRID' 1385 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1386 1387 -- Deprecation in 1.2.3 925 1388 CREATEFUNCTION getBBOX(geometry) 926 1389 RETURNS box2d … … 928 1391 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 929 1392 1393 -- Availability: 1.2.2 1394 CREATEFUNCTION getBBOX(geometry) 1395 RETURNS box2d 1396 AS '@MODULE_FILENAME@','LWGEOM_to_BOX2DFLOAT4' 1397 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1398 930 1399 ------------------------------------------- 931 1400 --- CHIP functions 932 1401 ------------------------------------------- 933 1402 1403 -- Deprecation in 1.2.3 934 1404 CREATEFUNCTION srid(chip) 935 1405 RETURNS int4 … … 937 1407 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 938 1408 1409 -- Availability: 1.2.2 1410 CREATEFUNCTION ST_srid(chip) 1411 RETURNS int4 1412 AS '@MODULE_FILENAME@','CHIP_getSRID' 1413 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1414 1415 -- Deprecation in 1.2.3 939 1416 CREATEFUNCTION height(chip) 940 1417 RETURNS int4 … … 942 1419 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 943 1420 1421 -- Availability: 1.2.2 1422 CREATEFUNCTION ST_height(chip) 1423 RETURNS int4 1424 AS '@MODULE_FILENAME@','CHIP_getHeight' 1425 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1426 1427 -- Deprecation in 1.2.3 944 1428 CREATEFUNCTION factor(chip) 945 1429 RETURNS FLOAT4 … … 947 1431 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 948 1432 1433 -- Availability: 1.2.2 1434 CREATEFUNCTION ST_factor(chip) 1435 RETURNS FLOAT4 1436 AS '@MODULE_FILENAME@','CHIP_getFactor' 1437 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1438 1439 -- Deprecation in 1.2.3 949 1440 CREATEFUNCTION width(chip) 950 1441 RETURNS int4 … … 952 1443 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 953 1444 1445 -- Availability: 1.2.2 1446 CREATEFUNCTION ST_width(chip) 1447 RETURNS int4 1448 AS '@MODULE_FILENAME@','CHIP_getWidth' 1449 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1450 1451 -- Deprecation in 1.2.3 954 1452 CREATEFUNCTION datatype(chip) 955 1453 RETURNS int4 … … 957 1455 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 958 1456 1457 -- Availability: 1.2.2 1458 CREATEFUNCTION ST_datatype(chip) 1459 RETURNS int4 1460 AS '@MODULE_FILENAME@','CHIP_getDatatype' 1461 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1462 1463 -- Deprecation in 1.2.3 959 1464 CREATEFUNCTION compression(chip) 960 1465 RETURNS int4 … … 962 1467 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 963 1468 1469 -- Availability: 1.2.2 1470 CREATEFUNCTION ST_compression(chip) 1471 RETURNS int4 1472 AS '@MODULE_FILENAME@','CHIP_getCompression' 1473 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1474 1475 -- Deprecation in 1.2.3 964 1476 CREATEFUNCTION setSRID(chip,int4) 965 1477 RETURNS chip … … 967 1479 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 968 1480 1481 -- Deprecation in 1.2.3 969 1482 CREATEFUNCTION setFactor(chip,float4) 970 1483 RETURNS chip … … 972 1485 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 973 1486 1487 -- Availability: 1.2.2 1488 CREATEFUNCTION ST_setFactor(chip,float4) 1489 RETURNS chip 1490 AS '@MODULE_FILENAME@','CHIP_setFactor' 1491 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1492 974 1493 ------------------------------------------------------------------------ 975 1494 -- DEBUG 976 1495 ------------------------------------------------------------------------ 977 1496 1497 -- Deprecation in 1.2.3 978 1498 CREATEFUNCTION mem_size(geometry) 979 1499 RETURNS int4 … … 981 1501 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 982 1502 1503 -- Availability: 1.2.2 1504 CREATEFUNCTION ST_mem_size(geometry) 1505 RETURNS int4 1506 AS '@MODULE_FILENAME@', 'LWGEOM_mem_size' 1507 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1508 1509 -- Deprecation in 1.2.3 983 1510 CREATEFUNCTION summary(geometry) 984 1511 RETURNS text … … 986 1513 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 987 1514 1515 -- Availability: 1.2.2 1516 CREATEFUNCTION ST_summary(geometry) 1517 RETURNS text 1518 AS '@MODULE_FILENAME@', 'LWGEOM_summary' 1519 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1520 1521 -- Deprecation in 1.2.3 988 1522 CREATEFUNCTION npoints(geometry) 989 1523 RETURNS int4 … … 991 1525 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 992 1526 1527 -- Availability: 1.2.2 1528 CREATEFUNCTION ST_npoints(geometry) 1529 RETURNS int4 1530 AS '@MODULE_FILENAME@', 'LWGEOM_npoints' 1531 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1532 1533 -- Deprecation in 1.2.3 993 1534 CREATEFUNCTION nrings(geometry) 994 1535 RETURNS int4 … … 996 1537 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 997 1538 1539 -- Availability: 1.2.2 1540 CREATEFUNCTION ST_nrings(geometry) 1541 RETURNS int4 1542 AS '@MODULE_FILENAME@', 'LWGEOM_nrings' 1543 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1544 998 1545 ------------------------------------------------------------------------ 999 1546 -- Misures … … 1002 1549 -- this is a fake (for back-compatibility) 1003 1550 -- uses 3d if 3d is available, 2d otherwise 1551 -- Deprecation in 1.2.3 1004 1552 CREATEFUNCTION length3d(geometry) 1005 1553 RETURNS FLOAT8 … … 1007 1555 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1008 1556 1557 -- Availability: 1.2.2 1558 CREATEFUNCTION ST_length3d(geometry) 1559 RETURNS FLOAT8 1560 AS '@MODULE_FILENAME@', 'LWGEOM_length_linestring' 1561 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1562 1563 -- Deprecation in 1.2.3 1009 1564 CREATEFUNCTION length2d(geometry) 1010 1565 RETURNS FLOAT8 … … 1012 1567 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1013 1568 1569 -- Availability: 1.2.2 1570 CREATEFUNCTION ST_length2d(geometry) 1571 RETURNS FLOAT8 1572 AS '@MODULE_FILENAME@', 'LWGEOM_length2d_linestring' 1573 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1574 1014 1575 CREATEFUNCTION length(geometry) 1015 1576 RETURNS FLOAT8 … … 1019 1580 -- this is a fake (for back-compatibility) 1020 1581 -- uses 3d if 3d is available, 2d otherwise 1582 -- Deprecation in 1.2.3 1021 1583 CREATEFUNCTION length3d_spheroid(geometry, spheroid) 1022 1584 RETURNS FLOAT8 … … 1024 1586 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1025 1587 1588 -- Availability: 1.2.2 1589 CREATEFUNCTION ST_length3d_spheroid(geometry, spheroid) 1590 RETURNS FLOAT8 1591 AS '@MODULE_FILENAME@','LWGEOM_length_ellipsoid_linestring' 1592 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1593 1594 -- Deprecation in 1.2.3 1026 1595 CREATEFUNCTION length_spheroid(geometry, spheroid) 1027 1596 RETURNS FLOAT8 … … 1029 1598 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1030 1599 1600 -- Availability: 1.2.2 1601 CREATEFUNCTION ST_length_spheroid(geometry, spheroid) 1602 RETURNS FLOAT8 1603 AS '@MODULE_FILENAME@','LWGEOM_length_ellipsoid_linestring' 1604 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1605 1606 -- Deprecation in 1.2.3 1031 1607 CREATEFUNCTION length2d_spheroid(geometry, spheroid) 1032 1608 RETURNS FLOAT8 … … 1034 1610 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1035 1611 1612 -- Availability: 1.2.2 1613 CREATEFUNCTION ST_length2d_spheroid(geometry, spheroid) 1614 RETURNS FLOAT8 1615 AS '@MODULE_FILENAME@','LWGEOM_length2d_ellipsoid_linestring' 1616 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1617 1036 1618 -- this is a fake (for back-compatibility) 1037 1619 -- uses 3d if 3d is available, 2d otherwise 1620 -- Deprecation in 1.2.3 1038 1621 CREATEFUNCTION perimeter3d(geometry) 1039 1622 RETURNS FLOAT8 … … 1041 1624 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1042 1625 1626 -- Availability: 1.2.2 1627 CREATEFUNCTION ST_perimeter3d(geometry) 1628 RETURNS FLOAT8 1629 AS '@MODULE_FILENAME@', 'LWGEOM_perimeter_poly' 1630 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1631 1632 -- Deprecation in 1.2.3 1043 1633 CREATEFUNCTION perimeter2d(geometry) 1044 1634 RETURNS FLOAT8 … … 1046 1636 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1047 1637 1638 -- Availability: 1.2.2 1639 CREATEFUNCTION ST_perimeter2d(geometry) 1640 RETURNS FLOAT8 1641 AS '@MODULE_FILENAME@', 'LWGEOM_perimeter2d_poly' 1642 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1643 1644 -- Deprecation in 1.2.3 1048 1645 CREATEFUNCTION perimeter(geometry) 1049 1646 RETURNS FLOAT8 … … 1053 1650 -- this is an alias for 'area(geometry)' 1054 1651 -- there is nothing such an 'area3d'... 1652 -- Deprecation in 1.2.3 1055 1653 CREATEFUNCTION area2d(geometry) 1056 1654 RETURNS FLOAT8 … … 1058 1656 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1059 1657 1658 -- Availability: 1.2.2 1659 CREATEFUNCTION ST_area2d(geometry) 1660 RETURNS FLOAT8 1661 AS '@MODULE_FILENAME@', 'LWGEOM_area_polygon' 1662 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1663 1664 -- Deprecation in 1.2.3 1060 1665 CREATEFUNCTION area(geometry) 1061 1666 RETURNS FLOAT8 … … 1063 1668 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1064 1669 1670 -- Deprecation in 1.2.3 1065 1671 CREATEFUNCTION distance_spheroid(geometry,geometry,spheroid) 1066 1672 RETURNS FLOAT8 … … 1068 1674 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1069 1675 1676 -- Availability: 1.2.2 1677 CREATEFUNCTION ST_distance_spheroid(geometry,geometry,spheroid) 1678 RETURNS FLOAT8 1679 AS '@MODULE_FILENAME@','LWGEOM_distance_ellipsoid_point' 1680 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1681 1682 -- Deprecation in 1.2.3 1070 1683 CREATEFUNCTION distance_sphere(geometry,geometry) 1071 1684 RETURNS FLOAT8 … … 1073 1686 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1074 1687 1688 -- Availability: 1.2.2 1689 CREATEFUNCTION ST_distance_sphere(geometry,geometry) 1690 RETURNS FLOAT8 1691 AS '@MODULE_FILENAME@','LWGEOM_distance_sphere' 1692 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1693 1075 1694 -- Minimum distance. 2d only. 1695 -- Deprecation in 1.2.3 1076 1696 CREATEFUNCTION distance(geometry,geometry) 1077 1697 RETURNS float8 … … 1080 1700 1081 1701 -- Maximum distance between linestrings. 2d only. Very bogus. 1702 -- Deprecation in 1.2.3 1082 1703 CREATEFUNCTION max_distance(geometry,geometry) 1083 1704 RETURNS float8 … … 1085 1706 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1086 1707 1708 -- Availability: 1.2.2 1709 CREATEFUNCTION ST_max_distance(geometry,geometry) 1710 RETURNS float8 1711 AS '@MODULE_FILENAME@', 'LWGEOM_maxdistance2d_linestring' 1712 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1713 1714 -- Deprecation in 1.2.3 1087 1715 CREATEFUNCTION point_inside_circle(geometry,float8,float8,float8) 1088 1716 RETURNS bool … … 1090 1718 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1091 1719 1720 -- Availability: 1.2.2 1721 CREATEFUNCTION ST_point_inside_circle(geometry,float8,float8,float8) 1722 RETURNS bool 1723 AS '@MODULE_FILENAME@', 'LWGEOM_inside_circle_point' 1724 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1725 1726 -- Deprecation in 1.2.3 1092 1727 CREATEFUNCTION azimuth(geometry,geometry) 1093 1728 RETURNS float8 … … 1095 1730 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1096 1731 1732 -- Availability: 1.2.2 1733 CREATEFUNCTION ST_azimuth(geometry,geometry) 1734 RETURNS float8 1735 AS '@MODULE_FILENAME@', 'LWGEOM_azimuth' 1736 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1097 1737 1098 1738 ------------------------------------------------------------------------ … … 1100 1740 ------------------------------------------------------------------------ 1101 1741 1742 -- Deprecation in 1.2.3 1102 1743 CREATEFUNCTION force_2d(geometry) 1103 1744 RETURNS geometry … … 1105 1746 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1106 1747 1748 -- Availability: 1.2.2 1749 CREATEFUNCTION ST_force_2d(geometry) 1750 RETURNS geometry 1751 AS '@MODULE_FILENAME@', 'LWGEOM_force_2d' 1752 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1753 1754 -- Deprecation in 1.2.3 1107 1755 CREATEFUNCTION force_3dz(geometry) 1108 1756 RETURNS geometry … … 1110 1758 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1111 1759 1760 -- Availability: 1.2.2 1761 CREATEFUNCTION ST_force_3dz(geometry) 1762 RETURNS geometry 1763 AS '@MODULE_FILENAME@', 'LWGEOM_force_3dz' 1764 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1765 1112 1766 -- an alias for force_3dz 1767 -- Deprecation in 1.2.3 1113 1768 CREATEFUNCTION force_3d(geometry) 1114 1769 RETURNS geometry … … 1116 1771 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1117 1772 1773 -- Availability: 1.2.2 1774 CREATEFUNCTION ST_force_3d(geometry) 1775 RETURNS geometry 1776 AS '@MODULE_FILENAME@', 'LWGEOM_force_3dz' 1777 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1778 1779 -- Deprecation in 1.2.3 1118 1780 CREATEFUNCTION force_3dm(geometry) 1119 1781 RETURNS geometry … … 1121 1783 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1122 1784 1785 -- Availability: 1.2.2 1786 CREATEFUNCTION ST_force_3dm(geometry) 1787 RETURNS geometry 1788 AS '@MODULE_FILENAME@', 'LWGEOM_force_3dm' 1789 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1790 1791 -- Deprecation in 1.2.3 1123 1792 CREATEFUNCTION force_4d(geometry) 1124 1793 RETURNS geometry … … 1126 1795 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1127 1796 1797 -- Availability: 1.2.2 1798 CREATEFUNCTION ST_force_4d(geometry) 1799 RETURNS geometry 1800 AS '@MODULE_FILENAME@', 'LWGEOM_force_4d' 1801 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1802 1803 -- Deprecation in 1.2.3 1128 1804 CREATEFUNCTION force_collection(geometry) 1129 1805 RETURNS geometry … … 1131 1807 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1132 1808 1809 -- Availability: 1.2.2 1810 CREATEFUNCTION ST_force_collection(geometry) 1811 RETURNS geometry 1812 AS '@MODULE_FILENAME@', 'LWGEOM_force_collection' 1813 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1814 1815 -- Deprecation in 1.2.3 1133 1816 CREATEFUNCTION multi(geometry) 1134 1817 RETURNS geometry … … 1136 1819 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1137 1820 1821 -- Availability: 1.2.2 1822 CREATEFUNCTION ST_multi(geometry) 1823 RETURNS geometry 1824 AS '@MODULE_FILENAME@', 'LWGEOM_force_multi' 1825 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1826 1827 -- Deprecation in 1.2.3 1138 1828 CREATEFUNCTION collector(geometry, geometry) 1139 1829 RETURNS geometry … … 1141 1831 LANGUAGE 'C' _IMMUTABLE; 1142 1832 1143 CREATEFUNCTION collect(geometry, geometry) 1833 -- Availability: 1.2.2 1834 CREATEFUNCTION ST_collector(geometry, geometry) 1144 1835 RETURNS geometry 1145 1836 AS '@MODULE_FILENAME@', 'LWGEOM_collect' 1146 1837 LANGUAGE 'C' _IMMUTABLE; 1147 1838 1839 -- Deprecation in 1.2.3 1840 CREATEFUNCTION collect(geometry, geometry) 1841 RETURNS geometry 1842 AS '@MODULE_FILENAME@', 'LWGEOM_collect' 1843 LANGUAGE 'C' _IMMUTABLE; 1844 1845 -- Availability: 1.2.2 1846 CREATEFUNCTION ST_collect(geometry, geometry) 1847 RETURNS geometry 1848 AS '@MODULE_FILENAME@', 'LWGEOM_collect' 1849 LANGUAGE 'C' _IMMUTABLE; 1850 1851 -- Deprecation in 1.2.3 1148 1852 CREATE AGGREGATE memcollect( 1149 sfunc = collect,1853 sfunc = ST_collect, 1150 1854 basetype = geometry, 1151 1855 stype = geometry 1152 1856 ); 1153 1857 1858 -- Availability: 1.2.2 1859 CREATE AGGREGATE ST_memcollect( 1860 sfunc = ST_collect, 1861 basetype = geometry, 1862 stype = geometry 1863 ); 1864 1865 -- Deprecation in 1.2.3 1154 1866 CREATEFUNCTION geom_accum (geometry[],geometry) 1155 1867 RETURNS geometry[] … … 1157 1869 LANGUAGE 'C' _IMMUTABLE; 1158 1870 1871 -- Availability: 1.2.2 1872 CREATEFUNCTION ST_geom_accum (geometry[],geometry) 1873 RETURNS geometry[] 1874 AS '@MODULE_FILENAME@', 'LWGEOM_accum' 1875 LANGUAGE 'C' _IMMUTABLE; 1876 1877 -- Deprecation in 1.2.3 1159 1878 CREATE AGGREGATE accum ( 1160 sfunc = geom_accum,1879 sfunc = ST_geom_accum, 1161 1880 basetype = geometry, 1162 1881 stype = geometry[] 1163 1882 ); 1164 1883 1884 -- Availability: 1.2.2 1885 CREATE AGGREGATE ST_accum ( 1886 sfunc = ST_geom_accum, 1887 basetype = geometry, 1888 stype = geometry[] 1889 ); 1890 1891 -- Deprecation in 1.2.3 1165 1892 CREATEFUNCTION collect_garray (geometry[]) 1166 1893 RETURNS geometry … … 1168 1895 LANGUAGE 'C' _IMMUTABLE_STRICT; 1169 1896 1897 -- Availability: 1.2.2 1898 CREATEFUNCTION ST_collect_garray (geometry[]) 1899 RETURNS geometry 1900 AS '@MODULE_FILENAME@', 'LWGEOM_collect_garray' 1901 LANGUAGE 'C' _IMMUTABLE_STRICT; 1902 1903 -- Deprecation in 1.2.3 1170 1904 CREATE AGGREGATE collect ( 1171 sfunc = geom_accum,1905 sfunc = ST_geom_accum, 1172 1906 basetype = geometry, 1173 1907 stype = geometry[], 1174 finalfunc = collect_garray1908 finalfunc = ST_collect_garray 1175 1909 ); 1176 1910 1911 1912 -- Availability: 1.2.2 1913 CREATE AGGREGATE ST_collect ( 1914 sfunc = ST_geom_accum, 1915 basetype = geometry, 1916 stype = geometry[], 1917 finalfunc = ST_collect_garray 1918 ); 1919 1920 -- Deprecation in 1.2.3 1177 1921 CREATEFUNCTION expand(box3d,float8) 1178 1922 RETURNS box3d … … 1180 1924 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1181 1925 1926 -- Availability: 1.2.2 1927 CREATEFUNCTION ST_expand(box3d,float8) 1928 RETURNS box3d 1929 AS '@MODULE_FILENAME@', 'BOX3D_expand' 1930 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1931 1932 -- Deprecation in 1.2.3 1182 1933 CREATEFUNCTION expand(box2d,float8) 1183 1934 RETURNS box2d … … 1185 1936 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1186 1937 1938 -- Availability: 1.2.2 1939 CREATEFUNCTION ST_expand(box2d,float8) 1940 RETURNS box2d 1941 AS '@MODULE_FILENAME@', 'BOX2DFLOAT4_expand' 1942 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1943 1944 -- Deprecation in 1.2.3 1187 1945 CREATEFUNCTION expand(geometry,float8) 1188 1946 RETURNS geometry … … 1190 1948 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1191 1949 1950 -- Availability: 1.2.2 1951 CREATEFUNCTION ST_expand(geometry,float8) 1952 RETURNS geometry 1953 AS '@MODULE_FILENAME@', 'LWGEOM_expand' 1954 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1955 1956 -- Deprecation in 1.2.3 1192 1957 CREATEFUNCTION envelope(geometry) 1193 1958 RETURNS geometry … … 1195 1960 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1196 1961 1962 -- Deprecation in 1.2.3 1197 1963 CREATEFUNCTION reverse(geometry) 1198 1964 RETURNS geometry … … 1200 1966 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1201 1967 1968 -- Availability: 1.2.2 1969 CREATEFUNCTION reverse(geometry) 1970 RETURNS geometry 1971 AS '@MODULE_FILENAME@', 'LWGEOM_reverse' 1972 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1973 1974 -- Deprecation in 1.2.3 1202 1975 CREATEFUNCTION ForceRHR(geometry) 1203 1976 RETURNS geometry … … 1205 1978 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1206 1979 1980 -- Availability: 1.2.2 1981 CREATEFUNCTION ForceRHR(geometry) 1982 RETURNS geometry 1983 AS '@MODULE_FILENAME@', 'LWGEOM_forceRHR_poly' 1984 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1985 1986 -- Deprecation in 1.2.3 1207 1987 CREATEFUNCTION noop(geometry) 1208 1988 RETURNS geometry … … 1210 1990 LANGUAGE 'C' _VOLATILE_STRICT; -- WITH (iscachable,isstrict); 1211 1991 1992 -- Availability: 1.2.2 1993 CREATEFUNCTION ST_noop(geometry) 1994 RETURNS geometry 1995 AS '@MODULE_FILENAME@', 'LWGEOM_noop' 1996 LANGUAGE 'C' _VOLATILE_STRICT; -- WITH (iscachable,isstrict); 1997 1998 -- Deprecation in 1.2.3 1212 1999 CREATEFUNCTION zmflag(geometry) 1213 2000 RETURNS smallint … … 1215 2002 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1216 2003 2004 -- Availability: 1.2.2 2005 CREATEFUNCTION ST_zmflag(geometry) 2006 RETURNS smallint 2007 AS '@MODULE_FILENAME@', 'LWGEOM_zmflag' 2008 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2009 2010 -- Deprecation in 1.2.3 1217 2011 CREATEFUNCTION hasBBOX(geometry) 1218 2012 RETURNS bool … … 1220 2014 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1221 2015 2016 -- Availabitily: 1.2.2 2017 CREATEFUNCTION hasBBOX(geometry) 2018 RETURNS bool 2019 AS '@MODULE_FILENAME@', 'LWGEOM_hasBBOX' 2020 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2021 2022 -- Deprecation in 1.2.3 1222 2023 CREATEFUNCTION ndims(geometry) 1223 2024 RETURNS smallint … … 1225 2026 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1226 2027 2028 -- Availability: 1.2.2 2029 CREATEFUNCTION ST_ndims(geometry) 2030 RETURNS smallint 2031 AS '@MODULE_FILENAME@', 'LWGEOM_ndims' 2032 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2033 2034 -- Deprecation in 1.2.3 1227 2035 CREATEFUNCTION AsEWKT(geometry) 1228 2036 RETURNS TEXT … … 1230 2038 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1231 2039 2040 -- Availability: 1.2.2 2041 CREATEFUNCTION ST_AsEWKT(geometry) 2042 RETURNS TEXT 2043 AS '@MODULE_FILENAME@','LWGEOM_asEWKT' 2044 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2045 2046 -- Deprecation in 1.2.3 1232 2047 CREATEFUNCTION AsEWKB(geometry) 1233 2048 RETURNS BYTEA … … 1235 2050 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1236 2051 2052 -- Availability: 1.2.2 2053 CREATEFUNCTION ST_AsEWKB(geometry) 2054 RETURNS BYTEA 2055 AS '@MODULE_FILENAME@','WKBFromLWGEOM' 2056 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2057 2058 -- Deprecation in 1.2.3 1237 2059 CREATEFUNCTION AsHEXEWKB(geometry) 1238 2060 RETURNS TEXT … … 1240 2062 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1241 2063 2064 -- Availability: 1.2.2 2065 CREATEFUNCTION ST_AsHEXEWKB(geometry) 2066 RETURNS TEXT 2067 AS '@MODULE_FILENAME@','LWGEOM_asHEXEWKB' 2068 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2069 2070 -- Deprecation in 1.2.3 1242 2071 CREATEFUNCTION AsHEXEWKB(geometry, text) 1243 2072 RETURNS TEXT … … 1245 2074 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1246 2075 2076 -- Availability: 1.2.2 2077 CREATEFUNCTION ST_AsHEXEWKB(geometry, text) 2078 RETURNS TEXT 2079 AS '@MODULE_FILENAME@','LWGEOM_asHEXEWKB' 2080 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2081 2082 -- Deprecation in 1.2.3 1247 2083 CREATEFUNCTION AsEWKB(geometry,text) 1248 2084 RETURNS bytea … … 1250 2086 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1251 2087 2088 -- Availability: 1.2.2 2089 CREATEFUNCTION ST_AsEWKB(geometry,text) 2090 RETURNS bytea 2091 AS '@MODULE_FILENAME@','WKBFromLWGEOM' 2092 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2093 2094 -- Deprecation in 1.2.3 1252 2095 CREATEFUNCTION GeomFromEWKB(bytea) 1253 2096 RETURNS geometry … … 1255 2098 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1256 2099 2100 -- Availability: 1.2.2 2101 CREATEFUNCTION ST_GeomFromEWKB(bytea) 2102 RETURNS geometry 2103 AS '@MODULE_FILENAME@','LWGEOMFromWKB' 2104 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2105 2106 -- Deprecation in 1.2.3 1257 2107 CREATEFUNCTION GeomFromEWKT(text) 1258 2108 RETURNS geometry … … 1260 2110 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1261 2111 2112 -- Availability: 1.2.2 2113 CREATEFUNCTION ST_GeomFromEWKT(text) 2114 RETURNS geometry 2115 AS '@MODULE_FILENAME@','parse_WKT_lwgeom' 2116 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2117 2118 -- Deprecation in 1.2.3 1262 2119 CREATEFUNCTION cache_bbox() 2120 RETURNS trigger 2121 AS '@MODULE_FILENAME@' 2122 LANGUAGE 'C'; 2123 2124 -- Availability: 1.2.2 2125 CREATEFUNCTION ST_cache_bbox() 1263 2126 RETURNS trigger 1264 AS '@MODULE_FILENAME@' 2127 AS '@MODULE_FILENAME@','cache_bbox' 1265 2128 LANGUAGE 'C'; 1266 2129 … … 1269 2132 ------------------------------------------------------------------------ 1270 2133 2134 -- Deprecation in 1.2.3 1271 2135 CREATEFUNCTION makePoint(float8, float8) 1272 2136 RETURNS geometry … … 1274 2138 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1275 2139 1276 CREATEFUNCTION makePoint(float8, float8, float8) 2140 -- Availability: 1.2.2 2141 CREATEFUNCTION ST_makePoint(float8, float8) 1277 2142 RETURNS geometry 1278 2143 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint' 1279 2144 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1280 2145 1281 CREATEFUNCTION makePoint(float8, float8, float8, float8) 2146 -- Deprecation in 1.2.3 2147 CREATEFUNCTION makePoint(float8, float8, float8) 1282 2148 RETURNS geometry 1283 2149 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint' 1284 2150 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1285 2151 2152 -- Availability: 1.2.2 2153 CREATEFUNCTION ST_makePoint(float8, float8, float8) 2154 RETURNS geometry 2155 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint' 2156 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2157 2158 -- Deprecation in 1.2.3 2159 CREATEFUNCTION makePoint(float8, float8, float8, float8) 2160 RETURNS geometry 2161 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint' 2162 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2163 2164 -- Availability: 1.2.2 2165 CREATEFUNCTION ST_makePoint(float8, float8, float8, float8) 2166 RETURNS geometry 2167 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint' 2168 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2169 2170 -- Deprecation in 1.2.3 1286 2171 CREATEFUNCTION makePointM(float8, float8, float8) 1287 2172 RETURNS geometry … … 1289 2174 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1290 2175 2176 -- Availability: 1.2.2 2177 CREATEFUNCTION makePointM(float8, float8, float8) 2178 RETURNS geometry 2179 AS '@MODULE_FILENAME@', 'LWGEOM_makepoint3dm' 2180 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2181 2182 -- Deprecation in 1.2.3 1291 2183 CREATEFUNCTION makeBox2d(geometry, geometry) 1292 2184 RETURNS box2d … … 1294 2186 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1295 2187 2188 -- Availability: 1.2.2 2189 CREATEFUNCTION ST_makeBox2d(geometry, geometry) 2190 RETURNS box2d 2191 AS '@MODULE_FILENAME@', 'BOX2DFLOAT4_construct' 2192 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2193 2194 -- Deprecation in 1.2.3 1296 2195 CREATEFUNCTION makeBox3d(geometry, geometry) 1297 2196 RETURNS box3d … … 1299 2198 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1300 2199 2200 -- Availability: 1.2.2 2201 CREATEFUNCTION ST_makeBox3d(geometry, geometry) 2202 RETURNS box3d 2203 AS '@MODULE_FILENAME@', 'BOX3D_construct' 2204 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2205 2206 -- Deprecation in 1.2.3 1301 2207 CREATEFUNCTION makeline_garray (geometry[]) 1302 2208 RETURNS geometry … … 1304 2210 LANGUAGE 'C' _IMMUTABLE_STRICT; 1305 2211 2212 -- Availability: 1.2.2 2213 CREATEFUNCTION ST_makeline_garray (geometry[]) 2214 RETURNS geometry 2215 AS '@MODULE_FILENAME@', 'LWGEOM_makeline_garray' 2216 LANGUAGE 'C' _IMMUTABLE_STRICT; 2217 2218 -- Deprecation in 1.2.3 1306 2219 CREATEFUNCTION LineFromMultiPoint(geometry) 1307 2220 RETURNS geometry … … 1309 2222 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1310 2223 2224 -- Availability: 1.2.2 2225 CREATEFUNCTION ST_LineFromMultiPoint(geometry) 2226 RETURNS geometry 2227 AS '@MODULE_FILENAME@', 'LWGEOM_line_from_mpoint' 2228 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2229 2230 -- Deprecation in 1.2.3 1311 2231 CREATEFUNCTION MakeLine(geometry, geometry) 1312 2232 RETURNS geometry … … 1314 2234 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1315 2235 2236 -- Availability: 1.2.2 2237 CREATEFUNCTION ST_MakeLine(geometry, geometry) 2238 RETURNS geometry 2239 AS '@MODULE_FILENAME@', 'LWGEOM_makeline' 2240 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2241 2242 -- Deprecation in 1.2.3 1316 2243 CREATEFUNCTION AddPoint(geometry, geometry) 1317 2244 RETURNS geometry … … 1319 2246 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1320 2247 1321 CREATEFUNCTION AddPoint(geometry, geometry, integer) 2248 -- Availability: 1.2.2 2249 CREATEFUNCTION ST_AddPoint(geometry, geometry) 1322 2250 RETURNS geometry 1323 2251 AS '@MODULE_FILENAME@', 'LWGEOM_addpoint' 1324 2252 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1325 2253 2254 -- Deprecation in 1.2.3 2255 CREATEFUNCTION AddPoint(geometry, geometry, integer) 2256 RETURNS geometry 2257 AS '@MODULE_FILENAME@', 'LWGEOM_addpoint' 2258 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2259 2260 -- Availability: 1.2.2 2261 CREATEFUNCTION ST_AddPoint(geometry, geometry, integer) 2262 RETURNS geometry 2263 AS '@MODULE_FILENAME@', 'LWGEOM_addpoint' 2264 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2265 2266 -- Deprecation in 1.2.3 1326 2267 CREATEFUNCTION RemovePoint(geometry, integer) 1327 2268 RETURNS geometry … … 1329 2270 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1330 2271 2272 -- Availability: 1.2.2 2273 CREATEFUNCTION ST_RemovePoint(geometry, integer) 2274 RETURNS geometry 2275 AS '@MODULE_FILENAME@', 'LWGEOM_removepoint' 2276 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2277 2278 -- Deprecation in 1.2.3 1331 2279 CREATEFUNCTION SetPoint(geometry, integer, geometry) 1332 2280 RETURNS geometry … … 1334 2282 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1335 2283 2284 -- Availability: 1.2.2 2285 CREATEFUNCTION ST_SetPoint(geometry, integer, geometry) 2286 RETURNS geometry 2287 AS '@MODULE_FILENAME@', 'LWGEOM_setpoint_linestring' 2288 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2289 2290 -- Deprecation in 1.2.3 1336 2291 CREATE AGGREGATE makeline ( 1337 2292 sfunc = geom_accum, … … 1341 2296 ); 1342 2297 2298 -- Availability: 1.2.2 2299 CREATE AGGREGATE ST_makeline ( 2300 sfunc = geom_accum, 2301 basetype = geometry, 2302 stype = geometry[], 2303 finalfunc = ST_makeline_garray 2304 ); 2305 2306 -- Deprecation in 1.2.3 1343 2307 CREATEFUNCTION MakePolygon(geometry, geometry[]) 1344 2308 RETURNS geometry … … 1346 2310 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1347 2311 1348 CREATEFUNCTION MakePolygon(geometry) 2312 -- Availability: 1.2.2 2313 CREATEFUNCTION ST_MakePolygon(geometry, geometry[]) 1349 2314 RETURNS geometry 1350 2315 AS '@MODULE_FILENAME@', 'LWGEOM_makepoly' 1351 2316 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1352 2317 2318 -- Deprecation in 1.2.3 2319 CREATEFUNCTION MakePolygon(geometry) 2320 RETURNS geometry 2321 AS '@MODULE_FILENAME@', 'LWGEOM_makepoly' 2322 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2323 2324 -- Availability: 1.2.2 2325 CREATEFUNCTION ST_MakePolygon(geometry) 2326 RETURNS geometry 2327 AS '@MODULE_FILENAME@', 'LWGEOM_makepoly' 2328 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2329 2330 -- Deprecation in 1.2.3 1353 2331 CREATEFUNCTION BuildArea(geometry) 1354 2332 RETURNS geometry … … 1356 2334 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 1357 2335 2336 -- Availability: 1.2.2 2337 CREATEFUNCTION ST_BuildArea(geometry) 2338 RETURNS geometry 2339 AS '@MODULE_FILENAME@', 'LWGEOM_buildarea' 2340 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (iscachable,isstrict); 2341 2342 -- Deprecation in 1.2.3 1358 2343 CREATEFUNCTION polygonize_garray (geometry[]) 1359 2344 RETURNS geometry … … 1361 2346 LANGUAGE 'C' _IMMUTABLE_STRICT; 1362 2347 2348 -- Availability: 1.2.2 2349 CREATEFUNCTION ST_polygonize_garray (geometry[]) 2350 RETURNS geometry 2351 AS '@MODULE_FILENAME@', 'polygonize_garray' 2352 LANGUAGE 'C' _IMMUTABLE_STRICT; 2353 2354 -- Deprecation in 1.2.3 1363 2355 CREATEFUNCTION LineMerge(geometry) 1364 2356 RETURNS geometry … … 1366 2358 LANGUAGE 'C' _IMMUTABLE_STRICT; 1367 2359 2360 -- Availability: 1.2.2 2361 CREATEFUNCTION ST_LineMerge(geometry) 2362 RETURNS geometry 2363 AS '@MODULE_FILENAME@', 'linemerge' 2364 LANGUAGE 'C' _IMMUTABLE_STRICT; 2365 2366 -- Deprecation in 1.2.3 1368 2367 CREATE AGGREGATE polygonize ( 1369 2368 sfunc = geom_accum, … … 1373 2372 ); 1374 2373 2374 -- Availability: 1.2.2 2375 CREATE AGGREGATE ST_polygonize ( 2376 sfunc = ST_geom_accum, 2377 basetype = geometry, 2378 stype = geometry[], 2379 finalfunc = ST_polygonize_garray 2380 ); 1375 2381 1376 2382 #if USE_VERSION > 72 … … 1378 2384 CREATE TYPE geometry_dump AS (path integer[], geom geometry); 1379 2385 2386 -- Deprecation in 1.2.3 1380 2387 CREATEFUNCTION Dump(geometry) 1381 2388 RETURNS SETOF geometry_dump … … 1383 2390 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1384 2391 2392 -- Availability: 1.2.2 2393 CREATEFUNCTION ST_Dump(geometry) 2394 RETURNS SETOF geometry_dump 2395 AS '@MODULE_FILENAME@', 'LWGEOM_dump' 2396 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2397 2398 -- Deprecation in 1.2.3 1385 2399 CREATEFUNCTION DumpRings(geometry) 1386 2400 RETURNS SETOF geometry_dump … … 1388 2402 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 1389 2403 2404 -- Availability: 1.2.2 2405 CREATEFUNCTION DumpRings(geometry) 2406 RETURNS SETOF geometry_dump 2407 AS '@MODULE_FILENAME@', 'LWGEOM_dump_rings' 2408 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2409 1390 2410 #endif 1391 2411 … … 1396 2416 -- 1397 2417 2418 -- Deprecation in 1.2.3 1398 2419 CREATEFUNCTION combine_bbox(box2d,geometry) 1399 2420 RETURNS box2d … … 1401 2422 LANGUAGE 'C' _IMMUTABLE; 1402 2423 2424 -- Availability: 1.2.2 2425 CREATEFUNCTION ST_combine_bbox(box2d,geometry) 2426 RETURNS box2d 2427 AS '@MODULE_FILENAME@', 'BOX2DFLOAT4_combine' 2428 LANGUAGE 'C' _IMMUTABLE; 2429 2430 -- Deprecation in 1.2.3 1403 2431 CREATE AGGREGATE extent( 1404 sfunc = combine_bbox,2432 sfunc = ST_combine_bbox, 1405 2433 basetype = geometry, 1406 2434 stype = box2d 1407 2435 ); 1408 2436 2437 -- Availability: 1.2.2 2438 CREATE AGGREGATE ST_extent( 2439 sfunc = ST_combine_bbox, 2440 basetype = geometry, 2441 stype = box2d 2442 ); 2443 2444 -- Deprecation in 1.2.3 1409 2445 CREATEFUNCTION combine_bbox(box3d,geometry) 1410 2446 RETURNS box3d … … 1412 2448 LANGUAGE 'C' _IMMUTABLE; 1413 2449 2450 -- Availability: 1.2.2 2451 CREATEFUNCTION ST_combine_bbox(box3d,geometry) 2452 RETURNS box3d 2453 AS '@MODULE_FILENAME@', 'BOX3D_combine' 2454 LANGUAGE 'C' _IMMUTABLE; 2455 2456 -- Deprecation in 1.2.3 1414 2457 CREATE AGGREGATE extent3d( 1415 2458 sfunc = combine_bbox, … … 1418 2461 ); 1419 2462 2463 -- Availability: 1.2.2 2464 CREATE AGGREGATE ST_extent3d( 2465 sfunc = ST_combine_bbox, 2466 basetype = geometry, 2467 stype = box3d 2468 ); 2469 1420 2470 ----------------------------------------------------------------------- 1421 2471 -- CREATE_HISTOGRAM2D( <box2d>, <size> ) … … 1425 2475 -- 1426 2476 ----------------------------------------------------------------------- 2477 -- Deprecation in 1.2.3 1427 2478 CREATEFUNCTION create_histogram2d(box2d,int) 1428 2479 RETURNS histogram2d … … 1430 2481 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1431 2482 2483 -- Availability: 1.2.2 2484 CREATEFUNCTION ST_create_histogram2d(box2d,int) 2485 RETURNS histogram2d 2486 AS '@MODULE_FILENAME@','create_lwhistogram2d' 2487 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 2488 1432 2489 ----------------------------------------------------------------------- 1433 2490 -- BUILD_HISTOGRAM2D( <histogram2d>, <tablename>, <columnname> ) 1434 2491 ----------------------------------------------------------------------- 2492 -- Deprecation in 1.2.3 1435 2493 CREATEFUNCTION build_histogram2d (histogram2d,text,text) 1436 2494 RETURNS histogram2d … … 1438 2496 LANGUAGE 'C' _STABLE_STRICT; -- WITH (isstrict); 1439 2497 2498 -- Availability: 1.2.2 2499 CREATEFUNCTION ST_build_histogram2d (histogram2d,text,text) 2500 RETURNS histogram2d 2501 AS '@MODULE_FILENAME@','build_lwhistogram2d' 2502 LANGUAGE 'C' _STABLE_STRICT; -- WITH (isstrict); 2503 1440 2504 #if USE_VERSION >= 73 1441 2505 ----------------------------------------------------------------------- … … 1445 2509 -- thanks to Carl Anderson for the idea. 1446 2510 ----------------------------------------------------------------------- 2511 -- Deprecation in 1.2.3 1447 2512 CREATEFUNCTION build_histogram2d (histogram2d,text,text,text) 1448 2513 RETURNS histogram2d … … 1454 2519 ' 1455 2520 LANGUAGE 'plpgsql' _STABLE_STRICT; -- WITH (isstrict); 2521 2522 -- Availability: 1.2.2 2523 CREATEFUNCTION ST_build_histogram2d (histogram2d,text,text,text) 2524 RETURNS histogram2d 2525 AS ' 2526 BEGIN 2527 EXECUTE ''SET local search_path = ''||$2||'',public''; 2528 RETURN public.build_histogram2d($1,$3,$4); 2529 END 2530 ' 2531 LANGUAGE 'plpgsql' _STABLE_STRICT; -- WITH (isstrict); 2532 1456 2533 #endif 1457 2534 … … 1459 2536 -- EXPLODE_HISTOGRAM2D( <histogram2d>, <tablename> ) 1460 2537 ----------------------------------------------------------------------- 2538 -- Deprecation in 1.2.3 1461 2539 CREATEFUNCTION explode_histogram2d (histogram2d,text) 1462 2540 RETURNS histogram2d … … 1464 2542 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1465 2543 2544 -- Availability: 1.2.2 2545 CREATEFUNCTION ST_explode_histogram2d (histogram2d,text) 2546 RETURNS histogram2d 2547 AS '@MODULE_FILENAME@','explode_lwhistogram2d' 2548 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 2549 1466 2550 ----------------------------------------------------------------------- 1467 2551 -- ESTIMATE_HISTOGRAM2D( <histogram2d>, <box> ) 1468 2552 ----------------------------------------------------------------------- 2553 -- Deprecation in 1.2.3 1469 2554 CREATEFUNCTION estimate_histogram2d(histogram2d,box2d) 1470 2555 RETURNS float8 … … 1472 2557 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 1473 2558 2559 -- Availability: 1.2.2 2560 CREATEFUNCTION ST_estimate_histogram2d(histogram2d,box2d) 2561 RETURNS float8 2562 AS '@MODULE_FILENAME@','estimate_lwhistogram2d' 2563 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 2564 1474 2565 ----------------------------------------------------------------------- 1475 2566 -- ESTIMATED_EXTENT( <schema name>, <table name>, <column name> ) 1476 2567 ----------------------------------------------------------------------- 2568 -- Deprecation in 1.2.3 1477 2569 CREATEFUNCTION estimated_extent(text,text,text) RETURNS box2d AS 1478 2570 '@MODULE_FILENAME@', 'LWGEOM_estimated_extent' 1479 2571 LANGUAGE 'C' _IMMUTABLE_STRICT _SECURITY_DEFINER; 1480 2572 2573 -- Availability: 1.2.2 2574 CREATEFUNCTION ST_estimated_extent(text,text,text) RETURNS box2d AS 2575 '@MODULE_FILENAME@', 'LWGEOM_estimated_extent' 2576 LANGUAGE 'C' _IMMUTABLE_STRICT _SECURITY_DEFINER; 2577 1481 2578 ----------------------------------------------------------------------- 1482 2579 -- ESTIMATED_EXTENT( <table name>, <column name> ) 1483 2580 ----------------------------------------------------------------------- 2581 -- Deprecation in 1.2.3 1484 2582 CREATEFUNCTION estimated_extent(text,text) RETURNS box2d AS 1485 2583 '@MODULE_FILENAME@', 'LWGEOM_estimated_extent' 1486 2584 LANGUAGE 'C' _IMMUTABLE_STRICT _SECURITY_DEFINER; 1487 2585 2586 -- Availability: 1.2.2 2587 CREATEFUNCTION ST_estimated_extent(text,text) RETURNS box2d AS 2588 '@MODULE_FILENAME@', 'LWGEOM_estimated_extent' 2589 LANGUAGE 'C' _IMMUTABLE_STRICT _SECURITY_DEFINER; 2590 1488 2591 ----------------------------------------------------------------------- 1489 2592 -- FIND_EXTENT( <schema name>, <table name>, <column name> ) 1490 2593 ----------------------------------------------------------------------- 2594 -- Deprecation in 1.2.3 1491 2595 CREATEFUNCTION find_extent(text,text,text) RETURNS box2d AS 1492 2596 ' … … 1505 2609 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; -- WITH (isstrict); 1506 2610 2611 -- Availability: 1.2.2 2612 CREATEFUNCTION ST_find_extent(text,text,text) RETURNS box2d AS 2613 ' 2614 DECLARE 2615 schemaname alias for $1; 2616 tablename alias for $2; 2617 columnname alias for $3; 2618 myrec RECORD; 2619 2620 BEGIN 2621 FOR myrec IN EXECUTE ''SELECT extent("''||columnname||''") FROM "''||schemaname||''"."''||tablename||''"'' LOOP 2622 return myrec.extent; 2623 END LOOP; 2624 END; 2625 ' 2626 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; -- WITH (isstrict); 2627 2628 1507 2629 ----------------------------------------------------------------------- 1508 2630 -- FIND_EXTENT( <table name>, <column name> ) 1509 2631 ----------------------------------------------------------------------- 2632 -- Deprecation in 1.2.3 1510 2633 CREATEFUNCTION find_extent(text,text) RETURNS box2d AS 2634 ' 2635 DECLARE 2636 tablename alias for $1; 2637 columnname alias for $2; 2638 myrec RECORD; 2639 2640 BEGIN 2641 FOR myrec IN EXECUTE ''SELECT extent("''||columnname||''") FROM "''||tablename||''"'' LOOP 2642 return myrec.extent; 2643 END LOOP; 2644 END; 2645 ' 2646 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; -- WITH (isstrict); 2647 2648 -- Availability: 1.2.2 2649 CREATEFUNCTION ST_find_extent(text,text) RETURNS box2d AS 1511 2650 ' 1512 2651 DECLARE … … 2701 3840 --------------------------------------------------------------- 2702 3841 3842 -- Deprecation in 1.2.3 2703 3843 CREATEFUNCTION box2d(geometry) 2704 3844 RETURNS box2d … … 2706 3846 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2707 3847 3848 -- Availability: 1.2.2 3849 CREATEFUNCTION ST_box2d(geometry) 3850 RETURNS box2d 3851 AS '@MODULE_FILENAME@','LWGEOM_to_BOX2DFLOAT4' 3852 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3853 3854 -- Deprecation in 1.2.3 2708 3855 CREATEFUNCTION box3d(geometry) 2709 3856 RETURNS box3d … … 2711 3858 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2712 3859 3860 -- Availability: 1.2.2 3861 CREATEFUNCTION ST_box3d(geometry) 3862 RETURNS box3d 3863 AS '@MODULE_FILENAME@','LWGEOM_to_BOX3D' 3864 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3865 3866 -- Deprecation in 1.2.3 2713 3867 CREATEFUNCTION box(geometry) 2714 3868 RETURNS box … … 2716 3870 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2717 3871 3872 -- Availability: 1.2.2 3873 CREATEFUNCTION ST_box(geometry) 3874 RETURNS box 3875 AS '@MODULE_FILENAME@','LWGEOM_to_BOX' 3876 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3877 3878 -- Deprecation in 1.2.3 2718 3879 CREATEFUNCTION box2d(box3d) 2719 3880 RETURNS box2d … … 2721 3882 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2722 3883 3884 -- Availability: 1.2.2 3885 CREATEFUNCTION ST_box2d(box3d) 3886 RETURNS box2d 3887 AS '@MODULE_FILENAME@','BOX3D_to_BOX2DFLOAT4' 3888 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3889 3890 -- Deprecation in 1.2.3 2723 3891 CREATEFUNCTION box3d(box2d) 2724 3892 RETURNS box3d … … 2726 3894 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2727 3895 3896 -- Availability: 1.2.2 3897 CREATEFUNCTION ST_box3d(box2d) 3898 RETURNS box3d 3899 AS '@MODULE_FILENAME@','BOX2DFLOAT4_to_BOX3D' 3900 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3901 3902 -- Deprecation in 1.2.3 2728 3903 CREATEFUNCTION box(box3d) 2729 3904 RETURNS box … … 2731 3906 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2732 3907 3908 -- Availability: 1.2.2 3909 CREATEFUNCTION ST_box(box3d) 3910 RETURNS box 3911 AS '@MODULE_FILENAME@','BOX3D_to_BOX' 3912 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3913 3914 -- Deprecation in 1.2.3 2733 3915 CREATEFUNCTION text(geometry) 2734 3916 RETURNS text … … 2736 3918 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2737 3919 3920 -- Availability: 1.2.2 3921 CREATEFUNCTION ST_text(geometry) 3922 RETURNS text 3923 AS '@MODULE_FILENAME@','LWGEOM_to_text' 3924 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3925 2738 3926 -- this is kept for backward-compatibility 3927 -- Deprecation in 1.2.3 2739 3928 CREATEFUNCTION box3dtobox(box3d) 2740 3929 RETURNS box … … 2742 3931 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2743 3932 3933 -- Deprecation in 1.2.3 2744 3934 CREATEFUNCTION geometry(box2d) 2745 3935 RETURNS geometry … … 2747 3937 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2748 3938 3939 -- Availability: 1.2.2 3940 CREATEFUNCTION ST_geometry(box2d) 3941 RETURNS geometry 3942 AS '@MODULE_FILENAME@','BOX2DFLOAT4_to_LWGEOM' 3943 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3944 3945 -- Deprecation in 1.2.3 2749 3946 CREATEFUNCTION geometry(box3d) 2750 3947 RETURNS geometry … … 2752 3949 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2753 3950 3951 -- Availability: 1.2.2 3952 CREATEFUNCTION ST_geometry(box3d) 3953 RETURNS geometry 3954 AS '@MODULE_FILENAME@','BOX3D_to_LWGEOM' 3955 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3956 3957 -- Deprecation in 1.2.3 2754 3958 CREATEFUNCTION geometry(text) 2755 3959 RETURNS geometry … … 2757 3961 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2758 3962 3963 -- Availability: 1.2.2 3964 CREATEFUNCTION ST_geometry(text) 3965 RETURNS geometry 3966 AS '@MODULE_FILENAME@','parse_WKT_lwgeom' 3967 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3968 3969 -- Deprecation in 1.2.3 2759 3970 CREATEFUNCTION geometry(chip) 2760 3971 RETURNS geometry … … 2762 3973 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2763 3974 3975 -- Availability: 1.2.2 3976 CREATEFUNCTION ST_geometry(chip) 3977 RETURNS geometry 3978 AS '@MODULE_FILENAME@','CHIP_to_LWGEOM' 3979 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3980 3981 -- Deprecation in 1.2.3 2764 3982 CREATEFUNCTION geometry(bytea) 2765 3983 RETURNS geometry … … 2767 3985 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2768 3986 3987 -- Availability: 1.2.2 3988 CREATEFUNCTION ST_geometry(bytea) 3989 RETURNS geometry 3990 AS '@MODULE_FILENAME@','LWGEOM_from_bytea' 3991 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3992 3993 -- Deprecation in 1.2.3 2769 3994 CREATEFUNCTION bytea(geometry) 2770 3995 RETURNS bytea … … 2772 3997 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2773 3998 3999 -- Availability: 1.2.2 4000 CREATEFUNCTION ST_bytea(geometry) 4001 RETURNS bytea 4002 AS '@MODULE_FILENAME@','LWGEOM_to_bytea' 4003 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4004 4005 -- Deprecation in 1.2.3 2774 4006 CREATEFUNCTION text(bool) 2775 4007 RETURNS text … … 2777 4009 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2778 4010 4011 -- Availability: 1.2.2 4012 CREATEFUNCTION ST_text(bool) 4013 RETURNS text 4014 AS '@MODULE_FILENAME@','BOOL_to_text' 4015 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4016 2779 4017 -- 7.3+ explicit casting definitions 2780 4018 #if USE_VERSION >= 73 2781 CREATE CAST (geometry AS box2d) WITH FUNCTION box2d(geometry) AS IMPLICIT;2782 CREATE CAST (geometry AS box3d) WITH FUNCTION box3d(geometry) AS IMPLICIT;2783 CREATE CAST (geometry AS box) WITH FUNCTION box(geometry) AS IMPLICIT;2784 CREATE CAST (box3d AS box2d) WITH FUNCTION box2d(box3d) AS IMPLICIT;2785 CREATE CAST (box2d AS box3d) WITH FUNCTION box3d(box2d) AS IMPLICIT;2786 CREATE CAST (box2d AS geometry) WITH FUNCTION geometry(box2d) AS IMPLICIT;2787 CREATE CAST (box3d AS box) WITH FUNCTION box(box3d) AS IMPLICIT;2788 CREATE CAST (box3d AS geometry) WITH FUNCTION geometry(box3d) AS IMPLICIT;2789 CREATE CAST (text AS geometry) WITH FUNCTION geometry(text) AS IMPLICIT;2790 CREATE CAST (geometry AS text) WITH FUNCTION text(geometry) AS IMPLICIT;2791 CREATE CAST (chip AS geometry) WITH FUNCTION geometry(chip) AS IMPLICIT;2792 CREATE CAST (bytea AS geometry) WITH FUNCTION geometry(bytea) AS IMPLICIT;2793 CREATE CAST (geometry AS bytea) WITH FUNCTION bytea(geometry) AS IMPLICIT;2794 CREATE CAST (bool AS text) WITH FUNCTION text(bool) AS IMPLICIT;4019 CREATE CAST (geometry AS box2d) WITH FUNCTION ST_box2d(geometry) AS IMPLICIT; 4020 CREATE CAST (geometry AS box3d) WITH FUNCTION ST_box3d(geometry) AS IMPLICIT; 4021 CREATE CAST (geometry AS box) WITH FUNCTION ST_box(geometry) AS IMPLICIT; 4022 CREATE CAST (box3d AS box2d) WITH FUNCTION ST_box2d(box3d) AS IMPLICIT; 4023 CREATE CAST (box2d AS box3d) WITH FUNCTION ST_box3d(box2d) AS IMPLICIT; 4024 CREATE CAST (box2d AS geometry) WITH FUNCTION ST_geometry(box2d) AS IMPLICIT; 4025 CREATE CAST (box3d AS box) WITH FUNCTION ST_box(box3d) AS IMPLICIT; 4026 CREATE CAST (box3d AS geometry) WITH FUNCTION ST_geometry(box3d) AS IMPLICIT; 4027 CREATE CAST (text AS geometry) WITH FUNCTION ST_geometry(text) AS IMPLICIT; 4028 CREATE CAST (geometry AS text) WITH FUNCTION ST_text(geometry) AS IMPLICIT; 4029 CREATE CAST (chip AS geometry) WITH FUNCTION ST_geometry(chip) AS IMPLICIT; 4030 CREATE CAST (bytea AS geometry) WITH FUNCTION ST_geometry(bytea) AS IMPLICIT; 4031 CREATE CAST (geometry AS bytea) WITH FUNCTION ST_bytea(geometry) AS IMPLICIT; 4032 CREATE CAST (bool AS text) WITH FUNCTION ST_text(bool) AS IMPLICIT; 2795 4033 #endif 2796 4034 … … 2799 4037 --------------------------------------------------------------- 2800 4038 4039 -- Deprecation in 1.2.3 2801 4040 CREATEFUNCTION simplify(geometry, float8) 2802 4041 RETURNS geometry … … 2804 4043 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2805 4044 4045 -- Availability: 1.2.2 4046 CREATEFUNCTION ST_simplify(geometry, float8) 4047 RETURNS geometry 4048 AS '@MODULE_FILENAME@', 'LWGEOM_simplify2d' 4049 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4050 2806 4051 -- SnapToGrid(input, xoff, yoff, xsize, ysize) 4052 -- Deprecation in 1.2.3 2807 4053 CREATEFUNCTION SnapToGrid(geometry, float8, float8, float8, float8) 2808 4054 RETURNS geometry … … 2810 4056 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2811 4057 4058 -- Availability: 1.2.2 4059 CREATEFUNCTION ST_SnapToGrid(geometry, float8, float8, float8, float8) 4060 RETURNS geometry 4061 AS '@MODULE_FILENAME@', 'LWGEOM_snaptogrid' 4062 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4063 2812 4064 -- SnapToGrid(input, xsize, ysize) # offsets=0 4065 -- Deprecation in 1.2.3 2813 4066 CREATEFUNCTION SnapToGrid(geometry, float8, float8) 2814 4067 RETURNS geometry … … 2816 4069 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2817 4070 4071 -- Availability: 1.2.2 4072 CREATEFUNCTION ST_SnapToGrid(geometry, float8, float8) 4073 RETURNS geometry 4074 AS 'SELECT SnapToGrid($1, 0, 0, $2, $3)' 4075 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4076 2818 4077 -- SnapToGrid(input, size) # xsize=ysize=size, offsets=0 4078 -- Deprecation in 1.2.3 2819 4079 CREATEFUNCTION SnapToGrid(geometry, float8) 2820 4080 RETURNS geometry … … 2822 4082 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2823 4083 4084 -- Availability: 1.2.2 4085 CREATEFUNCTION ST_SnapToGrid(geometry, float8) 4086 RETURNS geometry 4087 AS 'SELECT SnapToGrid($1, 0, 0, $2, $2)' 4088 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4089 2824 4090 -- SnapToGrid(input, point_offsets, xsize, ysize, zsize, msize) 4091 -- Deprecation in 1.2.3 2825 4092 CREATEFUNCTION SnapToGrid(geometry, geometry, float8, float8, float8, float8) 2826 4093 RETURNS geometry … … 2828 4095 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2829 4096 4097 -- Availability: 1.2.2 4098 CREATEFUNCTION ST_SnapToGrid(geometry, geometry, float8, float8, float8, float8) 4099 RETURNS geometry 4100 AS '@MODULE_FILENAME@', 'LWGEOM_snaptogrid_pointoff' 4101 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4102 4103 -- Deprecation in 1.2.3 2830 4104 CREATEFUNCTION segmentize(geometry, float8) 4105 RETURNS geometry 4106 AS '@MODULE_FILENAME@', 'LWGEOM_segmentize2d' 4107 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4108 4109 -- Availability: 1.2.2 4110 CREATEFUNCTION ST_segmentize(geometry, float8) 2831 4111 RETURNS geometry 2832 4112 AS '@MODULE_FILENAME@', 'LWGEOM_segmentize2d' … … 2837 4117 --------------------------------------------------------------- 2838 4118 4119 -- Deprecation in 1.2.3 2839 4120 CREATEFUNCTION line_interpolate_point(geometry, float8) 2840 4121 RETURNS geometry … … 2842 4123 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2843 4124 4125 -- Availability: 1.2.2 4126 CREATEFUNCTION ST_line_interpolate_point(geometry, float8) 4127 RETURNS geometry 4128 AS '@MODULE_FILENAME@', 'LWGEOM_line_interpolate_point' 4129 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4130 4131 -- Deprecation in 1.2.3 2844 4132 CREATEFUNCTION line_substring(geometry, float8, float8) 2845 4133 RETURNS geometry … … 2847 4135 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2848 4136 4137 -- Availability: 1.2.2 4138 CREATEFUNCTION ST_line_substring(geometry, float8, float8) 4139 RETURNS geometry 4140 AS '@MODULE_FILENAME@', 'LWGEOM_line_substring' 4141 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4142 4143 -- Deprecation in 1.2.3 2849 4144 CREATEFUNCTION line_locate_point(geometry, geometry) 2850 4145 RETURNS float8 … … 2852 4147 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2853 4148 4149 -- Availability: 1.2.2 4150 CREATEFUNCTION ST_line_locate_point(geometry, geometry) 4151 RETURNS float8 4152 AS '@MODULE_FILENAME@', 'LWGEOM_line_locate_point' 4153 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4154 4155 -- Deprecation in 1.2.3 2854 4156 CREATEFUNCTION locate_between_measures(geometry, float8, float8) 2855 4157 RETURNS geometry … … 2857 4159 LANGUAGE 'C' _IMMUTABLE_STRICT; 2858 4160 4161 -- Availability: 1.2.2 4162 CREATEFUNCTION ST_locate_between_measures(geometry, float8, float8) 4163 RETURNS geometry 4164 AS '@MODULE_FILENAME@', 'LWGEOM_locate_between_m' 4165 LANGUAGE 'C' _IMMUTABLE_STRICT; 4166 4167 -- Deprecation in 1.2.3 2859 4168 CREATEFUNCTION locate_along_measure(geometry, float8) 4169 RETURNS geometry 4170 AS 'SELECT locate_between_measures($1, $2, $2)' 4171 LANGUAGE 'sql' _IMMUTABLE_STRICT; 4172 4173 -- Availability: 1.2.2 4174 CREATEFUNCTION ST_locate_along_measure(geometry, float8) 2860 4175 RETURNS geometry 2861 4176 AS 'SELECT locate_between_measures($1, $2, $2)' … … 2866 4181 --------------------------------------------------------------- 2867 4182 4183 -- Deprecation in 1.2.3 2868 4184 CREATEFUNCTION intersection(geometry,geometry) 2869 4185 RETURNS geometry … … 2871 4187 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2872 4188 4189 -- Availability: 1.2.2 4190 CREATEFUNCTION ST_intersection(geometry,geometry) 4191 RETURNS geometry 4192 AS '@MODULE_FILENAME@','intersection' 4193 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4194 4195 -- Deprecation in 1.2.3 2873 4196 CREATEFUNCTION buffer(geometry,float8) 2874 4197 RETURNS geometry … … 2876 4199 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2877 4200 4201 -- Availability: 1.2.2 4202 CREATEFUNCTION ST_buffer(geometry,float8) 4203 RETURNS geometry 4204 AS '@MODULE_FILENAME@','buffer' 4205 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4206 4207 -- Deprecation in 1.2.3 2878 4208 CREATEFUNCTION buffer(geometry,float8,integer) 2879 4209 RETURNS geometry 2880 4210 AS '@MODULE_FILENAME@','buffer' 2881 4211 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4212 4213 -- Availability: 1.2.2 4214 CREATEFUNCTION ST_buffer(geometry,float8,integer) 4215 RETURNS geometry 4216 AS '@MODULE_FILENAME@','buffer' 4217 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2882 4218 4219 -- Deprecation in 1.2.3 2883 4220 CREATEFUNCTION convexhull(geometry) 2884 4221 RETURNS geometry 2885 4222 AS '@MODULE_FILENAME@','convexhull' 2886 4223 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4224 4225 -- Availability: 1.2.2 4226 CREATEFUNCTION ST_convexhull(geometry) 4227 RETURNS geometry 4228 AS '@MODULE_FILENAME@','convexhull' 4229 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2887 4230 2888 4231 -- Deprecation in 1.2.3 2889 4232 CREATEFUNCTION difference(geometry,geometry) 2890 4233 RETURNS geometry 2891 4234 AS '@MODULE_FILENAME@','difference' 2892 4235 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4236 4237 -- Availability: 1.2.2 4238 CREATEFUNCTION ST_difference(geometry,geometry) 4239 RETURNS geometry 4240 AS '@MODULE_FILENAME@','difference' 4241 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2893 4242 4243 -- Deprecation in 1.2.3 2894 4244 CREATEFUNCTION boundary(geometry) 2895 4245 RETURNS geometry … … 2897 4247 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2898 4248 4249 -- Availability: 1.2.2 4250 CREATEFUNCTION ST_boundary(geometry) 4251 RETURNS geometry 4252 AS '@MODULE_FILENAME@','boundary' 4253 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4254 4255 -- Deprecation in 1.2.3 2899 4256 CREATEFUNCTION symdifference(geometry,geometry) 2900 4257 RETURNS geometry 2901 4258 AS '@MODULE_FILENAME@','symdifference' 2902 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2903 2904 4259 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4260 4261 -- Availability: 1.2.2 4262 CREATEFUNCTION ST_symdifference(geometry,geometry) 4263 RETURNS geometry 4264 AS '@MODULE_FILENAME@','symdifference' 4265 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4266 4267 -- Deprecation in 1.2.3 2905 4268 CREATEFUNCTION symmetricdifference(geometry,geometry) 2906 4269 RETURNS geometry … … 2908 4271 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2909 4272 2910 4273 -- Availability: 1.2.2 4274 CREATEFUNCTION ST_symmetricdifference(geometry,geometry) 4275 RETURNS geometry 4276 AS '@MODULE_FILENAME@','symdifference' 4277 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4278 4279 -- Deprecation in 1.2.3 2911 4280 CREATEFUNCTION GeomUnion(geometry,geometry) 2912 4281 RETURNS geometry … … 2914 4283 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2915 4284 4285 -- Availability: 1.2.2 4286 CREATEFUNCTION ST_Union(geometry,geometry) 4287 RETURNS geometry 4288 AS '@MODULE_FILENAME@','geomunion' 4289 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4290 4291 -- Deprecation in 1.2.3 2916 4292 CREATE AGGREGATE MemGeomUnion ( 2917 4293 basetype = geometry, … … 2920 4296 ); 2921 4297 4298 -- Availability: 1.2.2 4299 CREATE AGGREGATE ST_MemGeomUnion ( 4300 basetype = geometry, 4301 sfunc = ST_union, 4302 stype = geometry 4303 ); 4304 4305 -- Deprecation in 1.2.3 2922 4306 CREATEFUNCTION unite_garray (geometry[]) 2923 4307 RETURNS geometry 2924 AS '@MODULE_FILENAME@'4308 AS '@MODULE_FILENAME@' 2925 4309 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2926 4310 4311 -- Availability: 1.2.2 4312 CREATEFUNCTION ST_unite_garray (geometry[]) 4313 RETURNS geometry 4314 AS '@MODULE_FILENAME@','unite_garray' 4315 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4316 4317 -- Deprecation in 1.2.3 2927 4318 CREATE AGGREGATE GeomUnion ( 2928 4319 sfunc = geom_accum, 2929 4320 basetype = geometry, 2930 4321 stype = geometry[], 2931 finalfunc = unite_garray4322 finalfunc = ST_unite_garray 2932 4323 ); 2933 4324 2934 4325 -- Availability: 1.2.2 4326 CREATE AGGREGATE ST_Union ( 4327 sfunc = ST_geom_accum, 4328 basetype = geometry, 4329 stype = geometry[], 4330 finalfunc = ST_unite_garray 4331 ); 4332 4333 -- Deprecation in 1.2.3 2935 4334 CREATEFUNCTION relate(geometry,geometry) 2936 4335 RETURNS text … … 2938 4337 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2939 4338 4339 -- Availability: 1.2.2 4340 CREATEFUNCTION ST_relate(geometry,geometry) 4341 RETURNS text 4342 AS '@MODULE_FILENAME@','relate_full' 4343 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4344 4345 -- Deprecation in 1.2.3 2940 4346 CREATEFUNCTION relate(geometry,geometry,text) 2941 4347 RETURNS boolean … … 2943 4349 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2944 4350 4351 -- Availability: 1.2.2 4352 CREATEFUNCTION ST_relate(geometry,geometry,text) 4353 RETURNS boolean 4354 AS '@MODULE_FILENAME@','relate_pattern' 4355 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4356 4357 -- Deprecation in 1.2.3 2945 4358 CREATEFUNCTION disjoint(geometry,geometry) 2946 4359 RETURNS boolean 2947 4360 AS '@MODULE_FILENAME@' 2948 4361 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2949 4362 4363 -- Deprecation in 1.2.3 2950 4364 CREATEFUNCTION touches(geometry,geometry) 2951 4365 RETURNS boolean … … 2953 4367 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2954 4368 4369 -- Deprecation in 1.2.3 2955 4370 CREATEFUNCTION intersects(geometry,geometry) 2956 4371 RETURNS boolean … … 2958 4373 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2959 4374 4375 -- Deprecation in 1.2.3 2960 4376 CREATEFUNCTION crosses(geometry,geometry) 2961 4377 RETURNS boolean … … 2963 4379 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2964 4380 4381 -- Deprecation in 1.2.3 2965 4382 CREATEFUNCTION within(geometry,geometry) 2966 4383 RETURNS boolean … … 2968 4385 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2969 4386 4387 -- Deprecation in 1.2.3 2970 4388 CREATEFUNCTION contains(geometry,geometry) 2971 4389 RETURNS boolean … … 2973 4391 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2974 4392 4393 -- Deprecation in 1.2.3 2975 4394 CREATEFUNCTION overlaps(geometry,geometry) 2976 4395 RETURNS boolean … … 2978 4397 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2979 4398 4399 -- Deprecation in 1.2.3 2980 4400 CREATEFUNCTION IsValid(geometry) 2981 4401 RETURNS boolean … … 2983 4403 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 2984 4404 4405 -- Deprecation in 1.2.3 2985 4406 CREATEFUNCTION GEOSnoop(geometry) 2986 4407 RETURNS geometry … … 2988 4409 LANGUAGE 'C' _VOLATILE_STRICT; -- WITH (isstrict,iscachable); 2989 4410 4411 -- Deprecation in 1.2.3 2990 4412 CREATEFUNCTION JTSnoop(geometry) 2991 4413 RETURNS geometry … … 2999 4421 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3000 4422 4423 -- Availability: 1.2.2 4424 CREATEFUNCTION ST_Centroid(geometry) 4425 RETURNS geometry 4426 AS '@MODULE_FILENAME@','centroid' 4427 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4428 4429 -- Deprecation in 1.2.3 3001 4430 CREATEFUNCTION IsRing(geometry) 3002 4431 RETURNS boolean … … 3004 4433 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3005 4434 4435 -- Availability: 1.2.2 4436 CREATEFUNCTION ST_IsRing(geometry) 4437 RETURNS boolean 4438 AS '@MODULE_FILENAME@','isring' 4439 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4440 4441 -- Deprecation in 1.2.3 3006 4442 CREATEFUNCTION PointOnSurface(geometry) 3007 4443 RETURNS geometry 3008 4444 AS '@MODULE_FILENAME@' 3009 4445 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4446 4447 -- Availability: 1.2.2 4448 CREATEFUNCTION ST_PointOnSurface(geometry) 4449 RETURNS geometry 4450 AS '@MODULE_FILENAME@','pointonsurface' 4451 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3010 4452 4453 -- Deprecation in 1.2.3 3011 4454 CREATEFUNCTION IsSimple(geometry) 3012 4455 RETURNS boolean … … 3014 4457 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3015 4458 4459 -- Availability: 1.2.2 4460 CREATEFUNCTION ST_IsSimple(geometry) 4461 RETURNS boolean 4462 AS '@MODULE_FILENAME@', 'issimple' 4463 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4464 4465 -- Deprecation in 1.2.3 3016 4466 CREATEFUNCTION Equals(geometry,geometry) 3017 4467 RETURNS boolean … … 3019 4469 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3020 4470 4471 -- Availability: 1.2.2 4472 CREATEFUNCTION ST_Equals(geometry,geometry) 4473 RETURNS boolean 4474 AS '@MODULE_FILENAME@','geomequals' 4475 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4476 3021 4477 ----------------------------------------------------------------------- 3022 4478 -- SVG OUTPUT 3023 4479 ----------------------------------------------------------------------- 4480 -- Deprecation in 1.2.3 3024 4481 CREATEFUNCTION AsSVG(geometry,int4,int4) 3025 4482 RETURNS TEXT … … 3027 4484 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3028 4485 4486 -- Availability: 1.2.2 4487 CREATEFUNCTION ST_AsSVG(geometry,int4,int4) 4488 RETURNS TEXT 4489 AS '@MODULE_FILENAME@','assvg_geometry' 4490 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4491 4492 -- Deprecation in 1.2.3 3029 4493 CREATEFUNCTION AsSVG(geometry,int4) 3030 4494 RETURNS TEXT … … 3032 4496 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3033 4497 4498 -- Availability: 1.2.2 4499 CREATEFUNCTION ST_AsSVG(geometry,int4) 4500 RETURNS TEXT 4501 AS '@MODULE_FILENAME@','assvg_geometry' 4502 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4503 4504 -- Deprecation in 1.2.3 3034 4505 CREATEFUNCTION AsSVG(geometry) 3035 4506 RETURNS TEXT … … 3037 4508 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3038 4509 4510 -- Availability: 1.2.2 4511 CREATEFUNCTION ST_AsSVG(geometry) 4512 RETURNS TEXT 4513 AS '@MODULE_FILENAME@','assvg_geometry' 4514 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4515 3039 4516 ----------------------------------------------------------------------- 3040 4517 -- GML OUTPUT 3041 4518 ----------------------------------------------------------------------- 3042 4519 -- AsGML(geom, precision, version) 4520 -- Deprecation in 1.2.3 3043 4521 CREATEFUNCTION AsGML(geometry, int4, int4) 3044 4522 RETURNS TEXT … … 3046 4524 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3047 4525 4526 -- Availability: 1.2.2 4527 CREATEFUNCTION ST_AsGML(geometry, int4, int4) 4528 RETURNS TEXT 4529 AS '@MODULE_FILENAME@','LWGEOM_asGML' 4530 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4531 3048 4532 -- AsGML(geom, precision) / version=2 4533 -- Deprecation in 1.2.3 3049 4534 CREATEFUNCTION AsGML(geometry, int4) 3050 4535 RETURNS TEXT … … 3052 4537 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3053 4538 4539 -- Availability: 1.2.2 4540 CREATEFUNCTION ST_AsGML(geometry, int4) 4541 RETURNS TEXT 4542 AS '@MODULE_FILENAME@','LWGEOM_asGML' 4543 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4544 3054 4545 -- AsGML(geom) / precision=15 version=2 4546 -- Deprecation in 1.2.3 3055 4547 CREATEFUNCTION AsGML(geometry) 3056 4548 RETURNS TEXT … … 3058 4550 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3059 4551 4552 -- Availabiltiy: 1.2.2 4553 CREATEFUNCTION ST_AsGML(geometry) 4554 RETURNS TEXT 4555 AS '@MODULE_FILENAME@','LWGEOM_asGML' 4556 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4557 3060 4558 ----------------------------------------------------------------------- 3061 4559 -- KML OUTPUT 3062 4560 ----------------------------------------------------------------------- 3063 4561 -- AsUKML(geom, precision, version) 4562 -- Deprecation in 1.2.3 3064 4563 CREATEFUNCTION AsUKML(geometry, int4, int4) 3065 4564 RETURNS TEXT … … 3067 4566 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3068 4567 4568 -- Availability: 1.2.2 4569 CREATEFUNCTION ST_AsUKML(geometry, int4, int4) 4570 RETURNS TEXT 4571 AS '@MODULE_FILENAME@','LWGEOM_asKML' 4572 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4573 3069 4574 -- AsUKML(geom, precision) / version=2 4575 -- Deprecation in 1.2.3 3070 4576 CREATEFUNCTION AsUKML(geometry, int4) 3071 4577 RETURNS TEXT … … 3073 4579 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3074 4580 4581 -- Availability: 1.2.2 4582 CREATEFUNCTION ST_AsUKML(geometry, int4) 4583 RETURNS TEXT 4584 AS '@MODULE_FILENAME@','LWGEOM_asKML' 4585 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4586 3075 4587 -- AsUKML(geom) / precision=15 version=2 4588 -- Deprecation in 1.2.3 3076 4589 CREATEFUNCTION AsUKML(geometry) 3077 4590 RETURNS TEXT … … 3079 4592 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3080 4593 4594 -- Availability: 1.2.2 4595 CREATEFUNCTION ST_AsUKML(geometry) 4596 RETURNS TEXT 4597 AS '@MODULE_FILENAME@','LWGEOM_asKML' 4598 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4599 3081 4600 -- AsKML(geom, precision, version) 4601 -- Deprecation in 1.2.3 3082 4602 CREATE OR REPLACE FUNCTION AsKML(geometry, int4, int4) 3083 4603 RETURNS TEXT … … 3085 4605 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3086 4606 4607 -- Availability: 1.2.2 4608 CREATE OR REPLACE FUNCTION ST_AsKML(geometry, int4, int4) 4609 RETURNS TEXT 4610 AS 'SELECT AsUKML(transform($1,4326),$2,$3)' 4611 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4612 3087 4613 -- AsKML(geom, precision) / version=2 4614 -- Deprecation in 1.2.3 3088 4615 CREATE OR REPLACE FUNCTION AsKML(geometry, int4) 3089 4616 RETURNS TEXT … … 3091 4618 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3092 4619 4620 -- Availability: 1.2.2 4621 CREATE OR REPLACE FUNCTION ST_AsKML(geometry, int4) 4622 RETURNS TEXT 4623 AS 'SELECT AsUKML(transform($1,4326),$2)' 4624 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4625 3093 4626 -- AsKML(geom) / precision=15 version=2 4627 -- Deprecation in 1.2.3 3094 4628 CREATE OR REPLACE FUNCTION AsKML(geometry) 3095 4629 RETURNS TEXT … … 3097 4631 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3098 4632 4633 -- Availability: 1.2.2 4634 CREATE OR REPLACE FUNCTION ST_AsKML(geometry) 4635 RETURNS TEXT 4636 AS 'SELECT AsUKML(transform($1,4326))' 4637 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4638 3099 4639 ------------------------------------------------------------------------ 3100 4640 -- OGC defined 3101 4641 ------------------------------------------------------------------------ 3102 4642 4643 -- Deprecation in 1.2.3 3103 4644 CREATEFUNCTION NumPoints(geometry) 3104 4645 RETURNS int4 … … 3106 4647 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3107 4648 4649 -- Availability: 1.2.2 4650 CREATEFUNCTION ST_NumPoints(geometry) 4651 RETURNS int4 4652 AS '@MODULE_FILENAME@', 'LWGEOM_numpoints_linestring' 4653 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4654 4655 -- Deprecation in 1.2.3 3108 4656 CREATEFUNCTION NumGeometries(geometry) 3109 4657 RETURNS int4 … … 3111 4659 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3112 4660 4661 -- Availability: 1.2.2 4662 CREATEFUNCTION ST_NumGeometries(geometry) 4663 RETURNS int4 4664 AS '@MODULE_FILENAME@', 'LWGEOM_numgeometries_collection' 4665 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4666 4667 -- Deprecation in 1.2.3 3113 4668 CREATEFUNCTION GeometryN(geometry,integer) 3114 4669 RETURNS geometry … … 3116 4671 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3117 4672 4673 -- Availability: 1.2.2 4674 CREATEFUNCTION ST_GeometryN(geometry,integer) 4675 RETURNS geometry 4676 AS '@MODULE_FILENAME@', 'LWGEOM_geometryn_collection' 4677 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4678 4679 -- Deprecation in 1.2.3 3118 4680 CREATEFUNCTION Dimension(geometry) 3119 4681 RETURNS int4 … … 3121 4683 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3122 4684 4685 -- Availability: 1.2.2 4686 CREATEFUNCTION ST_Dimension(geometry) 4687 RETURNS int4 4688 AS '@MODULE_FILENAME@', 'LWGEOM_dimension' 4689 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4690 4691 -- Deprecation in 1.2.3 3123 4692 CREATEFUNCTION ExterioRring(geometry) 3124 4693 RETURNS geometry … … 3126 4695 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3127 4696 4697 -- Availability: 1.2.2 4698 CREATEFUNCTION ST_ExteriorRing(geometry) 4699 RETURNS geometry 4700 AS '@MODULE_FILENAME@','LWGEOM_exteriorring_polygon' 4701 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4702 4703 -- Deprecation in 1.2.3 3128 4704 CREATEFUNCTION NumInteriorRings(geometry) 3129 4705 RETURNS integer … … 3131 4707 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3132 4708 4709 -- Availability: 1.2.2 4710 CREATEFUNCTION ST_NumInteriorRings(geometry) 4711 RETURNS integer 4712 AS '@MODULE_FILENAME@','LWGEOM_numinteriorrings_polygon' 4713 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4714 4715 -- Deprecation in 1.2.3 3133 4716 CREATEFUNCTION NumInteriorRing(geometry) 3134 4717 RETURNS integer … … 3136 4719 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3137 4720 4721 -- Availability: 1.2.2 4722 CREATEFUNCTION ST_NumInteriorRing(geometry) 4723 RETURNS integer 4724 AS '@MODULE_FILENAME@','LWGEOM_numinteriorrings_polygon' 4725 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4726 4727 -- Deprecation in 1.2.3 3138 4728 CREATEFUNCTION InteriorRingN(geometry,integer) 3139 4729 RETURNS geometry … … 3141 4731 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3142 4732 4733 -- Availability: 1.2.2 4734 CREATEFUNCTION ST_InteriorRingN(geometry,integer) 4735 RETURNS geometry 4736 AS '@MODULE_FILENAME@','LWGEOM_interiorringn_polygon' 4737 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4738 4739 -- Deprecation in 1.2.3 3143 4740 CREATEFUNCTION GeometryType(geometry) 3144 4741 RETURNS text … … 3146 4743 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3147 4744 4745 -- Availability: 1.2.2 4746 CREATEFUNCTION ST_GeometryType(geometry) 4747 RETURNS text 4748 AS '@MODULE_FILENAME@', 'LWGEOM_getTYPE' 4749 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4750 4751 -- Deprecation in 1.2.3 3148 4752 CREATEFUNCTION PointN(geometry,integer) 3149 4753 RETURNS geometry … … 3151 4755 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3152 4756 4757 -- Availability: 1.2.2 4758 CREATEFUNCTION ST_PointN(geometry,integer) 4759 RETURNS geometry 4760 AS '@MODULE_FILENAME@','LWGEOM_pointn_linestring' 4761 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4762 4763 -- Deprecation in 1.2.3 3153 4764 CREATEFUNCTION X(geometry) 3154 4765 RETURNS float8 … … 3156 4767 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3157 4768 4769 -- Deprecation in 1.2.3 3158 4770 CREATEFUNCTION Y(geometry) 3159 4771 RETURNS float8 … … 3161 4773 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3162 4774 4775 -- Deprecation in 1.2.3 3163 4776 CREATEFUNCTION Z(geometry) 3164 4777 RETURNS float8 … … 3166 4779 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3167 4780 4781 -- Availability: 1.2.2 4782 CREATEFUNCTION ST_Z(geometry) 4783 RETURNS float8 4784 AS '@MODULE_FILENAME@','LWGEOM_z_point' 4785 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4786 4787 -- Deprecation in 1.2.3 3168 4788 CREATEFUNCTION M(geometry) 3169 4789 RETURNS float8 … … 3171 4791 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3172 4792 4793 -- Availability: 1.2.2 4794 CREATEFUNCTION ST_M(geometry) 4795 RETURNS float8 4796 AS '@MODULE_FILENAME@','LWGEOM_m_point' 4797 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 4798 4799 -- Deprecation in 1.2.3 3173 4800 CREATEFUNCTION StartPoint(geometry) 3174 4801 RETURNS geometry … … 3176 4803 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3177 4804 4805 -- Deprecation in 1.2.3 3178 4806 CREATEFUNCTION EndPoint(geometry) 3179 4807 RETURNS geometry … … 3181 4809 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3182 4810 4811 -- Deprecation in 1.2.3 3183 4812 CREATEFUNCTION IsClosed(geometry) 3184 4813 RETURNS boolean … … 3186 4815 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3187 4816 4817 -- Deprecation in 1.2.3 3188 4818 CREATEFUNCTION IsEmpty(geometry) 3189 4819 RETURNS boolean … … 3191 4821 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict); 3192 4822 4823 -- Deprecation in 1.2.3 3193 4824 CREATEFUNCTION SRID(geometry) 3194 4825 RETURNS int4 3195 4826 AS '@MODULE_FILENAME@','LWGEOM_getSRID' 3196 4827 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3197 4828 4829 -- Deprecation in 1.2.3 3198 4830 CREATEFUNCTION SetSRID(geometry,int4) 4831 RETURNS geometry 4832 AS '@MODULE_FILENAME@','LWGEOM_setSRID' 4833 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4834 4835 -- Availability: 1.2.2 4836 CREATEFUNCTION ST_SetSRID(geometry,int4) 3199 4837 RETURNS geometry 3200 4838 AS '@MODULE_FILENAME@','LWGEOM_setSRID' 3201 4839 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3202 4840 4841 -- Deprecation in 1.2.3 3203 4842 CREATEFUNCTION AsBinary(geometry) 3204 4843 RETURNS bytea … … 3206 4845 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3207 4846 4847 -- Deprecation in 1.2.3 3208 4848 CREATEFUNCTION AsBinary(geometry,text) 3209 4849 RETURNS bytea … … 3211 4851 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3212 4852 4853 -- Availability: 1.2.2 4854 CREATEFUNCTION ST_AsBinary(geometry,text) 4855 RETURNS bytea 4856 AS '@MODULE_FILENAME@','LWGEOM_asBinary' 4857 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4858 4859 -- Deprecation in 1.2.3 3213 4860 CREATEFUNCTION AsText(geometry) 3214 4861 RETURNS TEXT … … 3216 4863 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3217 4864 4865 -- Deprecation in 1.2.3 3218 4866 CREATEFUNCTION GeometryFromText(text) 3219 4867 RETURNS geometry … … 3221 4869 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3222 4870 4871 -- Availability: 1.2.2 4872 CREATEFUNCTION ST_GeometryFromText(text) 4873 RETURNS geometry 4874 AS '@MODULE_FILENAME@','LWGEOM_from_text' 4875 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4876 4877 -- Deprecation in 1.2.3 3223 4878 CREATEFUNCTION GeometryFromText(text, int4) 3224 4879 RETURNS geometry … … 3226 4881 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3227 4882 4883 -- Availability: 1.2.2 4884 CREATEFUNCTION ST_GeometryFromText(text, int4) 4885 RETURNS geometry 4886 AS '@MODULE_FILENAME@','LWGEOM_from_text' 4887 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4888 4889 -- Deprecation in 1.2.3 3228 4890 CREATEFUNCTION GeomFromText(text) 3229 4891 RETURNS geometry AS 'SELECT geometryfromtext($1)' 3230 4892 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3231 4893 4894 -- Availability: 1.2.2 4895 CREATEFUNCTION ST_GeomFromText(text) 4896 RETURNS geometry AS 'SELECT geometryfromtext($1)' 4897 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4898 4899 -- Deprecation in 1.2.3 3232 4900 CREATEFUNCTION GeomFromText(text, int4) 3233 4901 RETURNS geometry AS 'SELECT geometryfromtext($1, $2)' 3234 4902 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3235 4903 4904 -- Deprecation in 1.2.3 3236 4905 CREATEFUNCTION PointFromText(text) 3237 4906 RETURNS geometry … … 3243 4912 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3244 4913 4914 -- Availability: 1.2.2 4915 CREATEFUNCTION ST_PointFromText(text) 4916 RETURNS geometry 4917 AS ' 4918 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''POINT'' 4919 THEN GeomFromText($1) 4920 ELSE NULL END 4921 ' 4922 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4923 4924 -- Deprecation in 1.2.3 3245 4925 CREATEFUNCTION PointFromText(text, int4) 3246 4926 RETURNS geometry … … 3252 4932 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3253 4933 4934 -- Deprecation in 1.2.3 3254 4935 CREATEFUNCTION LineFromText(text) 3255 4936 RETURNS geometry … … 3261 4942 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3262 4943 4944 -- Availability: 1.2.2 4945 CREATEFUNCTION ST_LineFromText(text) 4946 RETURNS geometry 4947 AS ' 4948 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''LINESTRING'' 4949 THEN GeomFromText($1) 4950 ELSE NULL END 4951 ' 4952 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4953 4954 -- Deprecation in 1.2.3 3263 4955 CREATEFUNCTION LineFromText(text, int4) 3264 4956 RETURNS geometry … … 3270 4962 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3271 4963 4964 -- Deprecation in 1.2.3 3272 4965 CREATEFUNCTION LineStringFromText(text) 3273 4966 RETURNS geometry … … 3275 4968 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3276 4969 4970 -- Deprecation in 1.2.3 3277 4971 CREATEFUNCTION LineStringFromText(text, int4) 3278 4972 RETURNS geometry … … 3280 4974 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3281 4975 4976 -- Deprecation in 1.2.3 3282 4977 CREATEFUNCTION PolyFromText(text) 3283 4978 RETURNS geometry … … 3289 4984 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3290 4985 4986 -- Availability: 1.2.2 4987 CREATEFUNCTION ST_PolyFromText(text) 4988 RETURNS geometry 4989 AS ' 4990 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''POLYGON'' 4991 THEN GeomFromText($1) 4992 ELSE NULL END 4993 ' 4994 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 4995 4996 -- Deprecation in 1.2.3 3291 4997 CREATEFUNCTION PolyFromText(text, int4) 3292 4998 RETURNS geometry … … 3298 5004 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3299 5005 5006 -- Deprecation in 1.2.3 3300 5007 CREATEFUNCTION PolygonFromText(text, int4) 3301 5008 RETURNS geometry … … 3303 5010 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3304 5011 5012 -- Availability: 1.2.2 5013 CREATEFUNCTION ST_PolygonFromText(text, int4) 5014 RETURNS geometry 5015 AS 'SELECT PolyFromText($1, $2)' 5016 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5017 5018 -- Deprecation in 1.2.3 3305 5019 CREATEFUNCTION PolygonFromText(text) 3306 5020 RETURNS geometry … … 3308 5022 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3309 5023 5024 -- Availability: 1.2.2 5025 CREATEFUNCTION ST_PolygonFromText(text) 5026 RETURNS geometry 5027 AS 'SELECT PolyFromText($1)' 5028 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5029 5030 -- Deprecation in 1.2.3 3310 5031 CREATEFUNCTION MLineFromText(text, int4) 3311 5032 RETURNS geometry … … 3318 5039 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3319 5040 5041 -- Deprecation in 1.2.3 3320 5042 CREATEFUNCTION MLineFromText(text) 3321 5043 RETURNS geometry … … 3327 5049 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3328 5050 5051 -- Availability: 1.2.2 5052 CREATEFUNCTION ST_MLineFromText(text) 5053 RETURNS geometry 5054 AS ' 5055 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''MULTILINESTRING'' 5056 THEN GeomFromText($1) 5057 ELSE NULL END 5058 ' 5059 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5060 5061 -- Deprecation in 1.2.3 3329 5062 CREATEFUNCTION MultiLineStringFromText(text) 3330 5063 RETURNS geometry … … 3332 5065 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3333 5066 5067 -- Availability: 1.2.2 5068 CREATEFUNCTION ST_MultiLineStringFromText(text) 5069 RETURNS geometry 5070 AS 'SELECT MLineFromText($1)' 5071 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5072 5073 -- Deprecation in 1.2.3 3334 5074 CREATEFUNCTION MultiLineStringFromText(text, int4) 3335 5075 RETURNS geometry … … 3337 5077 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3338 5078 5079 -- Availability: 1.2.2 5080 CREATEFUNCTION ST_MultiLineStringFromText(text, int4) 5081 RETURNS geometry 5082 AS 'SELECT MLineFromText($1, $2)' 5083 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5084 5085 -- Deprecation in 1.2.3 3339 5086 CREATEFUNCTION MPointFromText(text, int4) 3340 5087 RETURNS geometry … … 3346 5093 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3347 5094 5095 -- Deprecation in 1.2.3 3348 5096 CREATEFUNCTION MPointFromText(text) 3349 5097 RETURNS geometry … … 3355 5103 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3356 5104 5105 -- Availability: 1.2.2 5106 CREATEFUNCTION ST_MPointFromText(text) 5107 RETURNS geometry 5108 AS ' 5109 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''MULTIPOINT'' 5110 THEN GeomFromText($1) 5111 ELSE NULL END 5112 ' 5113 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5114 5115 -- Deprecation in 1.2.3 3357 5116 CREATEFUNCTION MultiPointFromText(text, int4) 3358 5117 RETURNS geometry … … 3360 5119 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3361 5120 5121 -- Deprecation in 1.2.3 3362 5122 CREATEFUNCTION MultiPointFromText(text) 3363 5123 RETURNS geometry … … 3365 5125 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3366 5126 5127 -- Availability: 1.2.2 5128 CREATEFUNCTION ST_MultiPointFromText(text) 5129 RETURNS geometry 5130 AS 'SELECT MPointFromText($1)' 5131 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5132 5133 -- Deprecation in 1.2.3 5134 CREATEFUNCTION MultiPointFromText(text) 5135 RETURNS geometry 5136 AS 'SELECT MPointFromText($1)' 5137 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5138 5139 -- Availability: 1.2.2 5140 CREATEFUNCTION ST_MultiPointFromText(text) 5141 RETURNS geometry 5142 AS 'SELECT MPointFromText($1)' 5143 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5144 5145 -- Deprecation in 1.2.3 3367 5146 CREATEFUNCTION MPolyFromText(text, int4) 3368 5147 RETURNS geometry … … 3374 5153 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3375 5154 5155 -- Deprecation in 1.2.3 3376 5156 CREATEFUNCTION MPolyFromText(text) 3377 5157 RETURNS geometry … … 3383 5163 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3384 5164 5165 --Availability: 1.2.2 5166 CREATEFUNCTION ST_MPolyFromText(text) 5167 RETURNS geometry 5168 AS ' 5169 SELECT CASE WHEN geometrytype(GeomFromText($1)) = ''MULTIPOLYGON'' 5170 THEN GeomFromText($1) 5171 ELSE NULL END 5172 ' 5173 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5174 5175 -- Deprecation in 1.2.3 3385 5176 CREATEFUNCTION MultiPolygonFromText(text, int4) 3386 5177 RETURNS geometry … … 3388 5179 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3389 5180 5181 -- Availability: 1.2.2 5182 CREATEFUNCTION ST_MultiPolygonFromText(text, int4) 5183 RETURNS geometry 5184 AS 'SELECT MPolyFromText($1, $2)' 5185 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5186 5187 -- Deprecation in 1.2.3 3390 5188 CREATEFUNCTION MultiPolygonFromText(text) 3391 5189 RETURNS geometry … … 3393 5191 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3394 5192 5193 -- Availability: 1.2.2 5194 CREATEFUNCTION ST_MultiPolygonFromText(text) 5195 RETURNS geometry 5196 AS 'SELECT MPolyFromText($1)' 5197 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5198 5199 -- Deprecation in 1.2.3 3395 5200 CREATEFUNCTION GeomCollFromText(text, int4) 3396 5201 RETURNS geometry … … 3403 5208 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3404 5209 5210 -- Availability: 1.2.2 5211 CREATEFUNCTION ST_GeomCollFromText(text, int4) 5212 RETURNS geometry 5213 AS ' 5214 SELECT CASE 5215 WHEN geometrytype(GeomFromText($1, $2)) = ''GEOMETRYCOLLECTION'' 5216 THEN GeomFromText($1,$2) 5217 ELSE NULL END 5218 ' 5219 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5220 5221 -- Deprecation in 1.2.3 3405 5222 CREATEFUNCTION GeomCollFromText(text) 3406 5223 RETURNS geometry … … 3413 5230 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3414 5231 5232 -- Availability: 1.2.2 5233 CREATEFUNCTION ST_GeomCollFromText(text) 5234 RETURNS geometry 5235 AS ' 5236 SELECT CASE 5237 WHEN geometrytype(GeomFromText($1)) = ''GEOMETRYCOLLECTION'' 5238 THEN GeomFromText($1) 5239 ELSE NULL END 5240 ' 5241 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5242 5243 -- Deprecation in 1.2.3 3415 5244 CREATEFUNCTION GeomFromWKB(bytea) 3416 5245 RETURNS geometry … … 3418 5247 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3419 5248 5249 -- Availability: 1.2.2 5250 CREATEFUNCTION ST_GeomFromWKB(bytea) 5251 RETURNS geometry 5252 AS '@MODULE_FILENAME@','LWGEOM_from_WKB' 5253 LANGUAGE 'C' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5254 5255 -- Deprecation in 1.2.3 3420 5256 CREATEFUNCTION GeomFromWKB(bytea, int) 3421 5257 RETURNS geometry … … 3423 5259 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3424 5260 5261 -- Availability: 1.2.2 5262 CREATEFUNCTION ST_GeomFromWKB(bytea, int) 5263 RETURNS geometry 5264 AS 'SELECT setSRID(GeomFromWKB($1), $2)' 5265 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5266 5267 -- Deprecation in 1.2.3 3425 5268 CREATEFUNCTION PointFromWKB(bytea, int) 3426 5269 RETURNS geometry … … 3432 5275 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3433 5276 5277 -- Deprecation in 1.2.3 3434 5278 CREATEFUNCTION PointFromWKB(bytea) 3435 5279 RETURNS geometry … … 3441 5285 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3442 5286 5287 -- Availability: 1.2.2 5288 CREATEFUNCTION ST_PointFromWKB(bytea) 5289 RETURNS geometry 5290 AS ' 5291 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''POINT'' 5292 THEN GeomFromWKB($1) 5293 ELSE NULL END 5294 ' 5295 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5296 5297 -- Deprecation in 1.2.3 3443 5298 CREATEFUNCTION LineFromWKB(bytea, int) 3444 5299 RETURNS geometry … … 3450 5305 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3451 5306 5307 -- Deprecation in 1.2.3 3452 5308 CREATEFUNCTION LineFromWKB(bytea) 3453 5309 RETURNS geometry … … 3459 5315 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3460 5316 5317 -- Availability: 1.2.2 5318 CREATEFUNCTION ST_LineFromWKB(bytea) 5319 RETURNS geometry 5320 AS ' 5321 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''LINESTRING'' 5322 THEN GeomFromWKB($1) 5323 ELSE NULL END 5324 ' 5325 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5326 5327 -- Deprecation in 1.2.3 3461 5328 CREATEFUNCTION LinestringFromWKB(bytea, int) 3462 5329 RETURNS geometry … … 3468 5335 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3469 5336 5337 -- Availability: 1.2.2 5338 CREATEFUNCTION ST_LinestringFromWKB(bytea, int) 5339 RETURNS geometry 5340 AS ' 5341 SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = ''LINESTRING'' 5342 THEN GeomFromWKB($1, $2) 5343 ELSE NULL END 5344 ' 5345 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5346 5347 -- Deprecation in 1.2.3 3470 5348 CREATEFUNCTION LinestringFromWKB(bytea) 3471 5349 RETURNS geometry … … 3477 5355 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3478 5356 5357 -- Availability: 1.2.2 5358 CREATEFUNCTION ST_LinestringFromWKB(bytea) 5359 RETURNS geometry 5360 AS ' 5361 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''LINESTRING'' 5362 THEN GeomFromWKB($1) 5363 ELSE NULL END 5364 ' 5365 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5366 5367 -- Deprecation in 1.2.3 3479 5368 CREATEFUNCTION PolyFromWKB(bytea, int) 3480 5369 RETURNS geometry … … 3486 5375 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3487 5376 5377 -- Deprecation in 1.2.3 3488 5378 CREATEFUNCTION PolyFromWKB(bytea) 3489 5379 RETURNS geometry … … 3495 5385 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3496 5386 5387 -- Availability: 1.2.2 5388 CREATEFUNCTION ST_PolyFromWKB(bytea) 5389 RETURNS geometry 5390 AS ' 5391 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''POLYGON'' 5392 THEN GeomFromWKB($1) 5393 ELSE NULL END 5394 ' 5395 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5396 5397 -- Deprecation in 1.2.3 3497 5398 CREATEFUNCTION PolygonFromWKB(bytea, int) 3498 5399 RETURNS geometry … … 3504 5405 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3505 5406 5407 -- Availability: 1.2.2 5408 CREATEFUNCTION ST_PolygonFromWKB(bytea, int) 5409 RETURNS geometry 5410 AS ' 5411 SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = ''POLYGON'' 5412 THEN GeomFromWKB($1, $2) 5413 ELSE NULL END 5414 ' 5415 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5416 5417 -- Deprecation in 1.2.3 3506 5418 CREATEFUNCTION PolygonFromWKB(bytea) 3507 5419 RETURNS geometry … … 3513 5425 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3514 5426 5427 -- Availability: 1.2.2 5428 CREATEFUNCTION ST_PolygonFromWKB(bytea) 5429 RETURNS geometry 5430 AS ' 5431 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''POLYGON'' 5432 THEN GeomFromWKB($1) 5433 ELSE NULL END 5434 ' 5435 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5436 5437 -- Deprecation in 1.2.3 3515 5438 CREATEFUNCTION MPointFromWKB(bytea, int) 3516 5439 RETURNS geometry … … 3522 5445 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3523 5446 5447 -- Deprecation in 1.2.3 3524 5448 CREATEFUNCTION MPointFromWKB(bytea) 3525 5449 RETURNS geometry … … 3531 5455 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3532 5456 5457 -- Availability: 1.2.2 5458 CREATEFUNCTION ST_MPointFromWKB(bytea) 5459 RETURNS geometry 5460 AS ' 5461 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTIPOINT'' 5462 THEN GeomFromWKB($1) 5463 ELSE NULL END 5464 ' 5465 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5466 5467 -- Deprecation in 1.2.3 3533 5468 CREATEFUNCTION MultiPointFromWKB(bytea, int) 3534 5469 RETURNS geometry … … 3540 5475 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3541 5476 5477 -- Availability: 1.2.2 5478 CREATEFUNCTION ST_MultiPointFromWKB(bytea, int) 5479 RETURNS geometry 5480 AS ' 5481 SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = ''MULTIPOINT'' 5482 THEN GeomFromWKB($1, $2) 5483 ELSE NULL END 5484 ' 5485 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5486 5487 -- Deprecation in 1.2.3 3542 5488 CREATEFUNCTION MultiPointFromWKB(bytea) 3543 5489 RETURNS geometry … … 3549 5495 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3550 5496 5497 -- Availability: 1.2.2 5498 CREATEFUNCTION ST_MultiPointFromWKB(bytea) 5499 RETURNS geometry 5500 AS ' 5501 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTIPOINT'' 5502 THEN GeomFromWKB($1) 5503 ELSE NULL END 5504 ' 5505 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5506 5507 -- Deprecation in 1.2.3 3551 5508 CREATEFUNCTION MultiLineFromWKB(bytea, int) 3552 5509 RETURNS geometry … … 3558 5515 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3559 5516 5517 -- Availability: 1.2.2 5518 CREATEFUNCTION MultiLineFromWKB(bytea, int) 5519 RETURNS geometry 5520 AS ' 5521 SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = ''MULTILINESTRING'' 5522 THEN GeomFromWKB($1, $2) 5523 ELSE NULL END 5524 ' 5525 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5526 5527 -- Deprecation in 1.2.3 3560 5528 CREATEFUNCTION MultiLineFromWKB(bytea) 3561 5529 RETURNS geometry … … 3567 5535 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3568 5536 5537 -- Availability: 1.2.2 5538 CREATEFUNCTION ST_MultiLineFromWKB(bytea) 5539 RETURNS geometry 5540 AS ' 5541 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTILINESTRING'' 5542 THEN GeomFromWKB($1) 5543 ELSE NULL END 5544 ' 5545 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5546 5547 -- Deprecation in 1.2.3 3569 5548 CREATEFUNCTION MLineFromWKB(bytea, int) 3570 5549 RETURNS geometry … … 3576 5555 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3577 5556 5557 -- Deprecation in 1.2.3 3578 5558 CREATEFUNCTION MLineFromWKB(bytea) 3579 5559 RETURNS geometry … … 3585 5565 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3586 5566 5567 -- Availability: 1.2.2 5568 CREATEFUNCTION ST_MLineFromWKB(bytea) 5569 RETURNS geometry 5570 AS ' 5571 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTILINESTRING'' 5572 THEN GeomFromWKB($1) 5573 ELSE NULL END 5574 ' 5575 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5576 5577 -- Deprecation in 1.2.3 3587 5578 CREATEFUNCTION MPolyFromWKB(bytea, int) 3588 5579 RETURNS geometry … … 3594 5585 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3595 5586 5587 -- Deprecation in 1.2.3 3596 5588 CREATEFUNCTION MPolyFromWKB(bytea) 3597 5589 RETURNS geometry … … 3603 5595 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3604 5596 5597 -- Availability: 1.2.2 5598 CREATEFUNCTION ST_MPolyFromWKB(bytea) 5599 RETURNS geometry 5600 AS ' 5601 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTIPOLYGON'' 5602 THEN GeomFromWKB($1) 5603 ELSE NULL END 5604 ' 5605 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5606 5607 -- Deprecation in 1.2.3 3605 5608 CREATEFUNCTION MultiPolyFromWKB(bytea, int) 3606 5609 RETURNS geometry … … 3612 5615 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3613 5616 5617 -- Availability: 1.2.2 5618 CREATEFUNCTION ST_MultiPolyFromWKB(bytea, int) 5619 RETURNS geometry 5620 AS ' 5621 SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = ''MULTIPOLYGON'' 5622 THEN GeomFromWKB($1, $2) 5623 ELSE NULL END 5624 ' 5625 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5626 5627 -- Deprecation in 1.2.3 3614 5628 CREATEFUNCTION MultiPolyFromWKB(bytea) 3615 5629 RETURNS geometry … … 3621 5635 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3622 5636 5637 -- Availability: 1.2.2 5638 CREATEFUNCTION ST_MultiPolyFromWKB(bytea) 5639 RETURNS geometry 5640 AS ' 5641 SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = ''MULTIPOLYGON'' 5642 THEN GeomFromWKB($1) 5643 ELSE NULL END 5644 ' 5645 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5646 5647 -- Deprecation in 1.2.3 3623 5648 CREATEFUNCTION GeomCollFromWKB(bytea, int) 3624 5649 RETURNS geometry … … 3631 5656 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 3632 5657 5658 -- Availability: 1.2.2 5659 CREATEFUNCTION ST_GeomCollFromWKB(bytea, int) 5660 RETURNS geometry 5661 AS ' 5662 SELECT CASE 5663 WHEN geometrytype(GeomFromWKB($1, $2)) = ''GEOMETRYCOLLECTION'' 5664 THEN GeomFromWKB($1, $2) 5665 ELSE NULL END 5666 ' 5667 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5668 5669 -- Deprecation in 1.2.3 3633 5670 CREATEFUNCTION GeomCollFromWKB(bytea) 5671 RETURNS geometry 5672 AS ' 5673 SELECT CASE 5674 WHEN geometrytype(GeomFromWKB($1)) = ''GEOMETRYCOLLECTION'' 5675 THEN GeomFromWKB($1) 5676 ELSE NULL END 5677 ' 5678 LANGUAGE 'SQL' _IMMUTABLE_STRICT; -- WITH (isstrict,iscachable); 5679 5680 -- Availability: 1.2.2 5681 CREATEFUNCTION ST_GeomCollFromWKB(bytea) 3634 5682 RETURNS geometry 3635 5683 AS ' … … 3655 5703 -- Also, we profit from plpgsql to RAISE exceptions. 3656 5704 -- 5705 -- Deprecation in 1.2.3 3657 5706 CREATE OR REPLACE FUNCTION BdPolyFromText(text, integer) 3658 5707 RETURNS geometry … … 3683 5732 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; 3684 5733 5734 -- Availability: 1.2.2 5735 CREATE OR REPLACE FUNCTION ST_BdPolyFromText(text, integer) 5736 RETURNS geometry 5737 AS ' 5738 DECLARE 5739 geomtext alias for $1; 5740 srid alias for $2; 5741 mline geometry; 5742 geom geometry; 5743 BEGIN 5744 mline := MultiLineStringFromText(geomtext, srid); 5745 5746 IF mline IS NULL 5747 THEN 5748 RAISE EXCEPTION ''Input is not a MultiLinestring''; 5749 END IF; 5750 5751 geom := BuildArea(mline); 5752 5753 IF GeometryType(geom) != ''POLYGON'' 5754 THEN 5755 RAISE EXCEPTION ''Input returns more then a single polygon, try using BdMPolyFromText instead''; 5756 END IF; 5757 5758 RETURN geom; 5759 END; 5760 ' 5761 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; 5762 3685 5763 -- 3686 5764 -- SFSQL 1.1 … … 3695 5773 -- To raise an exception in case of invalid input. 3696 5774 -- 5775 -- Deprecation in 1.2.3 3697 5776 CREATEFUNCTION BdMPolyFromText(text, integer) 3698 5777 RETURNS geometry … … 3718 5797 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; 3719 5798 5799 -- Availability: 1.2.2 5800 CREATEFUNCTION ST_BdMPolyFromText(text, integer) 5801 RETURNS geometry 5802 AS ' 5803 DECLARE 5804 geomtext alias for $1; 5805 srid alias for $2; 5806 mline geometry; 5807 geom geometry; 5808 BEGIN 5809 mline := MultiLineStringFromText(geomtext, srid); 5810 5811 IF mline IS NULL 5812 THEN 5813 RAISE EXCEPTION ''Input is not a MultiLinestring''; 5814 END IF; 5815 5816 geom := multi(BuildArea(mline)); 5817 5818 RETURN geom; 5819 END; 5820 ' 5821 LANGUAGE 'plpgsql' _IMMUTABLE_STRICT; 5822 3720 5823 #include "long_xact.sql.in" 3721 5824 #include "sqlmm.sql.in"
