Re: Windows, ODBC drivers and strange points ...

Поиск
Список
Период
Сортировка
От Christian Schröder
Тема Re: Windows, ODBC drivers and strange points ...
Дата
Msg-id 434A5499.3010001@deriva.de
обсуждение исходный текст
Ответ на Re: Windows, ODBC drivers and strange points ...  (Marten Feldtmann <m.feldtmann@t-online.de>)
Список pgsql-odbc
Marten Feldtmann wrote:

> This means, that under PostgreSQL one should in general quote
> the column names when creating them ? Do I also have to quote
> them in the SELECT statements ???

Exactly. However, this is a database issue, not a driver issue. Quoting
http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS:

> Identifier and key word names are case insensitive. Therefore
>
>UPDATE MY_TABLE SET A = 5;
>
> can equivalently be written as
>
>uPDaTE my_TabLE SeT a = 5;
>
>[...]
>
>Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case. For
example,the identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are different
fromthese three and each other. 
>

Regards
     Christian


Вложения

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

Предыдущее
От: Cleber Nardelli
Дата:
Сообщение: Problem with psqlODBC on "Cache Size"
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Windows, ODBC drivers and strange points ...