hstore: null value is treated as empty string by avals function - Mailing list pgsql-bugs

From Alexey Bashtanov
Subject hstore: null value is treated as empty string by avals function
Date
Msg-id AANLkTinKTwHcgKnhhU6kTxwMcpkRBhEEkxeS_YgTut0C@mail.gmail.com
Whole thread Raw
Responses Re: hstore: null value is treated as empty string by avals function
List pgsql-bugs
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

regards,
 Alexey

pgsql-bugs by date:

Previous
From: "Henk Dekker"
Date:
Subject: BUG #5679: pgAdminIII 1.12.0 hangs
Next
From: Craig Ringer
Date:
Subject: Re: BUG #5679: pgAdminIII 1.12.0 hangs