Re: [MonetDB-users] Querying date type column in MonetDB

On 25-10-2010 17:27:39 +0200, Freddy Priyatna wrote:

Thanks Fabian

But

• SELECT offer.deliverydays FROM bsbm.offer

doesnt work.

I was confused last time. Everything that is typed is lowercased, hence also offer.deliveryDays, and does not match the "deliveryDays" one.

So the best way for me is

• SELECT "offer"."deliveryDays" FROM bsbm.offer

which matches the original creation, and is the best way in any case.

Sorry for the long wait.