On 2011-04-27 14:37, Georgios Garmpis wrote:
I have tried GeomFromText but it doesn't seem to return WKB.
sql>SELECT GeomFromText('POINT(1 2)', 0); +----------------------------------------------------------------------------+ | geomfromtext_single_value | +======================================+ | POINT (1.0000000000000000 2.0000000000000000) | +----------------------------------------------------------------------------+ 1 tuple (0.325ms)
Then what do you expect (or wish to get)? What would the WKB look like at the SQL level?
On Wed, Apr 27, 2011 at 3:30 PM, Sjoerd Mullender <sjoerd@acm.org <mailto: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> > <mailto: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> > <mailto: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> > <mailto: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 <mailto: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 <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