Skip site navigation (1) Skip section navigation (2)

Re: SQL problem?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: cbraden <cbraden(at)douglasknight(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL problem?
Date: 2005-08-24 17:15:50
Message-ID: 20050824101212.H90271@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 24 Aug 2005, cbraden wrote:

> Folks,
>
> I have a simple table called "adjusters" with only these three columns:
>
> id
> adjuster
> MonthlyGoal
>
> ==========COPIED FROM PGAdminIII=============
> CREATE TABLE public.adjusters
> (
> id int4 NOT NULL DEFAULT nextval('adjusters_id_key'::text),
> "Adjuster" varchar(50),
> "MonthlyGoal" varchar(50),
> CONSTRAINT adjusters_pkey PRIMARY KEY (id)
> ) WITH OIDS;
> ==============================================
>
> The SQL "SELECT * FROM adjusters" works perfectly
>
> The SQL "SELECT * FROM adjusters ORDER BY Adjuster ASC" results in this
> message:
> ERROR: Attribute "adjuster" not found

The column is not Adjuster, but "Adjuster".  Unquoted identifiers are case
folded in SQL (although we case fold the wrong direction for spec, it
doesn't matter in this case).

In response to

pgsql-novice by date

Next:From: William YuDate: 2005-08-25 11:42:49
Subject: Re: Transaction Questions
Previous:From: Kretschmer AndreasDate: 2005-08-24 17:08:04
Subject: Re: SQL problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group