pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Juan Riera <juanriera@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: PostgreSQL SELECT error
Date: Sun, 23 Dec 2001 17:23:37 +0100
Message-ID: <a050ee$9bi$1@news.tht.net> (raw)
References: <a02133$1s4a$1@news.tht.net>
	<a03id3$1b4$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?

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)
>





view thread (2+ messages)  latest in thread

Message-ID: <a050ee$9bi$1@news.tht.net>
Permalink:  ../a050ee$9bi$1@news.tht.net/
Also on:    postgresql.org/message-id/a050ee$9bi$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: juanriera@hotmail.com
  Subject: Re: PostgreSQL SELECT error
  In-Reply-To: <a050ee$9bi$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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