Hi Freddy,
I don't think that the error you experience is triggered by the column type, but rather by the fact that your date column ha? a name - say "date" - that is a reserved key word in SQL an hence needs to be double-quoted according to the SQL standard (this is not a MonetDB specific choice, but a "feature" of the SQL standard) --- not knowing your table & column names, I can only guess, though ...
Stefan
----- Oorspronkelijk bericht -----
Van: Freddy Priyatna <freddy.priyatna@gmail.com>
Verzonden: maandag 25 oktober 2010 16:03
Aan: MonetDB-users <monetdb-users@lists.sourceforge.net>
Onderwerp: [MonetDB-users] Querying date type column in MonetDB
------------------------------------------------------------------------------
Dear All,
I am new to MonetDB, so most likely my question will look obvious.
I would like to ask, how can columns with date type is queried in monetdb.
Based on my experience, it seems that date type columns need special
treatment. It seems that the only way to query them is with the syntax
"column_name" while other columns seems to work with the format
table_name.column_name without the need of double quote. When I tried to
query date column with the syntax table_name.column_name, it gave me an
error "no such column"
So my question is, is it true that the only way to query date columns is
using "column_name" format? Another question will be, what happen if I need
to query same name columns coming from different table?
Thanks in advance,
Freddy
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users