Another example would the following. Suppose that we have the table geometries(id INT, shape GEOMETRY) and we would like to retrieve the WKB and WKT representation of the geometry.
For example we would like to ask the following query:
select id, AsWKB(geo) AS GeoWKB, AsWKT(geo) AS GeoWKT
from geometries
Regards,
Kostis
On Wed, Apr 27, 2011 at 12:30 PM, Georgios Garmpis
<ggarbis@di.uoa.gr> wrote:
In SQLI need something like that SELECT AsWKB('POINT(1, 2)');
On Wed, Apr 27, 2011 at 12:09 PM,
<Stefan.Manegold@cwi.nl> wrote:
George,
where do you need to get the Well Known Binary representation of a geometry?
As documentation?
In C?
In MAL?
In SQL?
Stefan
On Wed, Apr 27, 2011 at 11:50:53AM +0300, Georgios Garmpis wrote:
> Hi,
>
> I need to get the Well Known Binary representation of a geometry but
> I didn't find any function in documentation to do this.
> Any ideas?
>
> --
> George Garbis
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today. Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
George Garbis
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users