Freddy

2010/10/25 Fabian Groffen <Fabian.Groffen@cwi.nl>

On 25-10-2010 17:09:27 +0200, Freddy Priyatna wrote:
> Dear Arjen,
>
> Thanks. I did check the uppercase letter.
>
> With a date-type column "deliveryDays" in a table "bsbm.offer", here is the
> result
>
> - SELECT "deliveryDays" FROM bsbm.offer --> WORKS

case matches

> - SELECT "deliverydays" FROM bsbm.offer --> FAILS

case mismatches

> - SELECT "offer.deliveryDays" FROM bsbm.offer --> FAILS

column named 'offer.deliveryDays' doesn't exist, you probably mean
"offer"."deliveryDays"

> - SELECT deliveryDays FROM bsbm.offer --> FAILS

this is weird, I'd expect it to match (as everything not quoted is
lowercased, as per the standard)

> - SELECT offer.deliveryDays FROM bsbm.offer --> FAILS

idem

> - SELECT offer."deliveryDays" FROM bsbm.offer ---> WORKS

sort of the same as the first one.

offer.deliverydays should work as well.

------------------------------------------------------------------------------
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