pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PostgreSQL SELECT error
2+ messages / 2 participants
[nested] [flat]
* Re: PostgreSQL SELECT error
@ 2001-12-23 16:23 Juan Riera <juanriera@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Juan Riera @ 2001-12-23 16:23 UTC (permalink / raw)
To: 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@frontiernet.net> escribió en el mensaje
news:a03id3$1b4$1@news.tht.net...
> > 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)
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL SELECT error
@ 2002-01-01 23:50 Calvin Dodge <caldodge@fpcc.net>
parent: Juan Riera <juanriera@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: caldodge@fpcc.net @ 2002-01-01 23:50 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-01-01 23:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-23 16:23 Re: PostgreSQL SELECT error Juan Riera <juanriera@hotmail.com>
2002-01-01 23:50 ` Calvin Dodge <caldodge@fpcc.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox