Re: Aubit4gl and Postgresql Postgis

it will be the "::geometry".
It doesnt understand that SQL - you'll need to PREPARE it to use it.

(ordinarily - you'd be able to use an SQL .. END SQL block, but colons (:)
are used to mark variables in there so it still fails)


On Thu, 27 Aug 2020 at 06:31, Carlos Alberto Correa Fayad <
[email protected]> wrote:

> Hi all
>
> I want to use Aubit4gl to query a Postgis geospatial base.
>
> I am running this command:
>
> SELECT name
>  FROM poligono
>  WHERE ST_Contains(wkb_geometry,ST_GeomFromWKB(ST_AsEWKB('POINT(-74.064358
> 4.701265)'::geometry), 4326))
>
>
> And it generates this error
>
>  Error at line 13, character 104
>  syntax error, unexpected 'geometry'  (geometry)
>
>
>
> Thank you
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss