sql>SELECT GeomFromText('POINT(1 2)', 0);

+----------------------------------------------------------------------------+

| geomfromtext_single_value |

+======================================+

| POINT (1.0000000000000000 2.0000000000000000) |

+----------------------------------------------------------------------------+

1 tuple (0.325ms)

On Wed, Apr 27, 2011 at 3:30 PM, Sjoerd Mullender <sjoerd@acm.org> wrote:

On 2011-04-27 11:30, Georgios Garmpis wrote:
> In SQL
>
> I need something like that SELECT AsWKB('POINT(1, 2)');

What about this:
SELECT GeomFromText('POINT(1 2)', 0);

The string ('POINT(1 2)') should not have a comma in it, and the extra
argument (0) is ignored.

> On Wed, Apr 27, 2011 at 12:09 PM, <Stefan.Manegold@cwi.nl

> <mailto: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

> <mailto: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

> <mailto: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

--

Sjoerd Mullender

------------------------------------------------------------------------------
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