| From: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
|---|---|
| To: | Alexey Bashtanov <bashtanov(at)nasvete(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: hstore: null value is treated as empty string by avals function |
| Date: | 2010-09-27 08:34:39 |
| Message-ID: | AANLkTik_Eatm8p6PBAvG70e-Ezj=p7+sPD4nyvcJxmTY@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Sep 27, 2010 at 2:36 PM, Alexey Bashtanov <bashtanov(at)nasvete(dot)ru> wrote:
> hstore: null value is treated as empty string by avals function
>
> # select avals('gfds'=>null) = array[null], avals('gfds'=>null) =
> array[''], version();
> ?column? | ?column? |
> version
> ----------+----------+------------------------------------------------------------------------------------------------------------------
> f | t | PostgreSQL 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?
--
Itagaki Takahiro
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fazal rahman | 2010-09-27 09:09:24 | Re: BUG #5678: libpq.so.4 is needed for pgadmin3 |
| Previous Message | Craig Ringer | 2010-09-27 05:38:08 | Re: BUG #5679: pgAdminIII 1.12.0 hangs |