Re: Problem with fixed length fields.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with fixed length fields.
Дата
Msg-id 26657.1098556819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem with fixed length fields.  (Kris Jurka <books@ejurka.com>)
Ответы Re: Problem with fixed length fields.  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Kris Jurka <books@ejurka.com> writes:
> This is a problem with the driver because it is typing the '  ' values as
> text, not char, so the comparison doesn't work right because these two
> types handle trailing spaces differently.

Can you refrain from assigning a type at all?  People writing the
equivalent SQL directly would almost always write 'foo', not
'foo'::text or 'foo'::char.  The parser's behavior has been tuned
so that that usually works nicely.

            regards, tom lane

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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Problem with fixed length fields.
Следующее
От: "Serguei Mokhov"
Дата:
Сообщение: Translation updates: ru.po