From: | "Juan Riera" <juanriera(at)hotmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: PostgreSQL SELECT error |
Date: | 2001-12-23 16:23:37 |
Message-ID: | a050ee$9bi$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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?
Thanks,
Juan
"Lee Harr" <missive(at)frontiernet(dot)net> escribi en el mensaje
news:a03id3$1b4$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> > I am trying SELECT CDART FROM PREVIS
> > where PREVIS is a table on my STOCKS database, and CDART is a data
column.
> > I get this error:
> >
> > Attribute 'cdart' not found
> >
> > but when I do SELECT * FROM PREVIS I get all my table OK including
column
> > CDART.
>
>
> How about
>
> SELECT "CDART" FROM previs
> ?
>
> Possibly you defined the table with quotes and all caps
> (which would make the identifier case sensitive, I believe)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Lebedev | 2001-12-26 02:49:48 | Re: won't drop the view |
Previous Message | Andrew G. Hammond | 2001-12-23 16:03:45 | Re: [SQL] HELP PLEASE: Error executing the example esql.xml on |