Re: Fwd: Using the inet and url type functions

23 May 2013


      cnelson@hpvm:/store/meps/db $ mclient -v
mclient, the MonetDB interactive terminal (Feb2013-SP2)
support for command-line editing compiled-in
character encoding: UTF-8

cnelson@hpvm:/store/meps/db $ sudo monetdb version
MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)


On Thu, May 23, 2013 at 2:41 PM, Niels Nes  wrote:
...
On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote:
...
sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL
ORDER BY src, ts LIMIT 5;
SELECT: no such unary operator 'text(inet)'
The text function should be part of the 14_inet.sql file which is
loaded the first time you start (the first) client. Which version
are you running?
Niels
...
On Thu, May 23, 2013 at 2:33 PM, Niels Nes  wrote:
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
...
_______________________________________________
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