Re: Very strange selectproblem

From: Francois Suter <francois(at)monpetitcoin(dot)com>
To: Victor Spång Arthursson <victor(at)tosti(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very strange selectproblem
Date: 2003-11-04 12:31:08
Message-ID: C45E3D6A-0EC2-11D8-9E6D-000393427520@monpetitcoin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> indiadan=# select varer.vNummer from varer;
> ERROR: No such attribute varer.vnummer
> indiadan=#

PostgreSQL casts all names to lowercase. To select your field, you need
to use double quotes, as in:

select varer."vNummer" from varer;

Cheers.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-11-04 12:32:15 Re: Very strange selectproblem
Previous Message Rob Fielding 2003-11-04 12:19:58 Re: pg7.3.4: pg_atoi: zero-length string