Re: Problems with join (no such attribute, but it exists)

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