Re: PostgreSQL SELECT error - Mailing list pgsql-sql

From caldodge@fpcc.net (Calvin Dodge)
Subject Re: PostgreSQL SELECT error
Date
Msg-id ca6275f0.0201011550.73371680@posting.google.com
Whole thread Raw
In response to Re: PostgreSQL SELECT error  ("Juan Riera" <juanriera@hotmail.com>)
List pgsql-sql
"Juan Riera" <juanriera@hotmail.com> wrote in message news:<a050ee$9bi$1@news.tht.net>...
> It works - thanks, Lee
> However I don't understand what happened as I have created this table
> through W98/ODBC from Approach and I did not put explicitly any quotes on
> variables. Maybe Approach does it? Can I eliminate this quotes from column
> names and put names in small caps?

Well, if you're not constantly recreating the table, why not rename the columns?

Something like:

Alter table previs rename "CDART" to cdart;

Calvin


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unpredictable text -> date implicit casting behaviour/to_date bug
Next
From: "Josh Berkus"
Date:
Subject: Re: Tree structure index usage