Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with join (no such attribute, but it exists) - Mailing list pgsql-novice

From Matej Cepl
Subject Re: Problems with join (no such attribute, but it exists)
Date
Msg-id slrnbcb94k.1l4.cepl@komensky.surfbest.net
Whole thread Raw
In response to Problems with join (no such attribute, but it exists)  (Matej Cepl <cepl@surfbest.net>)
List pgsql-novice
Tree view 
On 2003-05-16, 17:46 GMT, Juliet May wrote:
> PostgreSql doesn't recognize the column because the column name is in
> uppercase and you typed in lowercase. You need to surround the uppercase
> with quotes as well. Your query should have been written like:
>
>  grass=> SELECT conv."TRACT_ID", tr.tract FROM tracts_towns2000 conv,
> tracts2000 tr LIMIT 5;
>
> I hope that helps.

Thanks, it helped, but it seems to me silly (to be case-senstitive and
case-minimalizing in the same time).

Thanks anyway

   Matej

--
Matej Cepl,
GPG Finger: 89EF 4BC6 288A BF43 1BAB  25C3 E09F EF25 D964 84AC
138 Highland Ave. #10, Somerville, Ma 02143, (617) 623-1488

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: \copy command
Next
From: Nabil Sayegh
Date:
Subject: Re: Insert on create table