SQL problem?

Поиск
Список
Период
Сортировка
От cbraden
Тема SQL problem?
Дата
Msg-id 430C9EBF.5010905@douglasknight.com
обсуждение исходный текст
Ответ на Re: New-B Question #2  (Philip Hallstrom <postgresql@philip.pjkh.com>)
Ответы Re: SQL problem?
Re: SQL problem?
Список pgsql-novice
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


That SQL seems OK to me, but I use mySQL much more than Postgre, so what
do I know?

Anyway, if you see whatever-it-is which is holding me up, please let me
know.

Thanks,
Char-Lez Braden

В списке pgsql-novice по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Transaction Questions
Следующее
От: Kretschmer Andreas
Дата:
Сообщение: Re: SQL problem?