You need to double-quote the names or they will be converted to lower case.
Thank you both. The reason why the initial table creation have quoted columns names is that it's generated by a program we use for schema creation. I'm currently adding to it so it can support Postgres too and the way columns are set up was more or less copied from the MS Sql implementation.
I'm really not used to databases being so case sensitive, neither Oracle or MS Sql Server is that, but I'll keep this thing in mind moving along. Quite impressed with the response time, or maybe it was just a too easy question :-)
Best regards
Jan Oksfeldt Jonasen Northmann A/S web: http://www.northmann.com newsgroup: news:news.northmann.com
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly