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 Niels.Nes@cwi.nl 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 Niels.Nes@cwi.nl 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