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