On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote:
> Hi,
>
> I noticed in the manual that there are many useful functions for the
> inet and url types. For example, I would like to convert an inet column
> to text for use in a Python script (since the python-monetdb module
> does not support the inet type.)
>
> I tried:
>
> sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER
> BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in:
> "select wlid, text("

Text is a monetdb sql keyword, ie simply double quote text.

ie

SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER

BY src, ts LIMIT 5;

Niels

>
> sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL
> ORDER BY src, ts LIMIT 5;
> unexpected symbol (:)
>
> sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL
> ORDER BY src, ts LIMIT 5;
> syntax error, unexpected '(', expecting SCOLON in: "select wlid,
> inet.text("
>
> I have read through the manual sections on types and functions several
> times now, and I cannot see how to use the specified functions on these
> types. Any help would be greatly appreciated. 
>
> Thanks!
>
> -={C}=-
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes@cwi.nl

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list