Column Name = column does not exist

Поиск
Список
Период
Сортировка
От brian stapel
Тема Column Name = column does not exist
Дата
Msg-id BAY107-W4154BB2CCD4D0358C801BA1BC0@phx.gbl
обсуждение исходный текст
Ответы Re: Column Name = column does not exist
Re: Column Name = column does not exist
Список pgsql-novice
Thanks for your time.
 
I'm in the process of trying to incorporate three Human Resource systems into one.  Each of the three systems had a different author and no standards were followed - consequently the table design leaves a bit to be desired.  One of the most critical tables has a field named:Last_Name (case specific).  When I execute 'Select Last_Name from employee' the statement fails with the following message: column "last_name" does not exist.  If I wrap the field name in quotes "Last_Name" for example, the query works as expected.
 
Is this typical behavior?
 
Thanks again.


Get the Live.com Holiday Page for recipes, gift-giving ideas, and more. Check it out!

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

Предыдущее
От: Robert Rak
Дата:
Сообщение: Re: select from different database
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Column Name = column does not exist