Re: hstore: null value is treated as empty string by avals function

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: hstore: null value is treated as empty string by avals function
Дата
Msg-id AANLkTik_Eatm8p6PBAvG70e-Ezj=p7+sPD4nyvcJxmTY@mail.gmail.com
обсуждение исходный текст
Ответ на hstore: null value is treated as empty string by avals function  (Alexey Bashtanov <bashtanov@nasvete.ru>)
Ответы Re: hstore: null value is treated as empty string by avals function  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
On Mon, Sep 27, 2010 at 2:36 PM, Alexey Bashtanov <bashtanov@nasvete.ru> wr=
ote:
> hstore: null value is treated as empty string by avals function
>
> # select avals('gfds'=3D>null) =3D array[null], avals('gfds'=3D>null) =3D
> array[''], version();
> =C2=A0?column? | ?column? |
> =C2=A0 =C2=A0version
> ----------+----------+---------------------------------------------------=
---------------------------------------------------------------
> =C2=A0f =C2=A0 =C2=A0 =C2=A0 =C2=A0| t =C2=A0 =C2=A0 =C2=A0 =C2=A0| Postg=
reSQL 8.4.4 on x86_64-redhat-linux-gnu,
> compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit
> (1 row)
>
> got f,t
> expected t,f
> hope the problem is clear

I found 9.0 and 9.1dev returns t,f as expected.
Is it an incompatibility between 8.4 and 9.0?

--=20
Itagaki Takahiro

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: BUG #5679: pgAdminIII 1.12.0 hangs
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: BUG #5674: initdb failed if path contains symlink