>
> Stefan
>
>
> ----- Oorspronkelijk bericht -----
> Van: Freddy Priyatna <
freddy.priyatna@gmail.com>
> Verzonden: maandag 25 oktober 2010 16:32
> Aan: Communication channel for MonetDB users <
monetdb-users@lists.sourceforge.net>
> Onderwerp: Re: [MonetDB-users] Querying date type column in MonetDB
>
> Hi Stefan,
>
> Nope, the name of the column is "deliveryDays" :)
>
> Freddy
>
> 2010/10/25 Stefan Manegold <
Stefan.Manegold@cwi.nl>
>
>> 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
>>
>
> ------------------------------------------------------------------------------
> 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