Re: Very strange selectproblem - Mailing list 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