Thanks Fabian
But
- SELECT offer.deliverydays FROM bsbm.offer
doesnt work.
So the best way for me is
- SELECT "offer"."deliveryDays" FROM bsbm.offer
Regards
Freddy
2010/10/25 Fabian Groffen
Dear Arjen,
Thanks. I did check the uppercase letter.
With a date-type column "deliveryDays" in a table "bsbm.offer", here is
On 25-10-2010 17:09:27 +0200, Freddy Priyatna wrote: 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