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.