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

From: Alexey Bashtanov <bashtanov(at)nasvete(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: hstore: null value is treated as empty string by avals function
Date: 2010-09-27 05:36:39
Message-ID: AANLkTinKTwHcgKnhhU6kTxwMcpkRBhEEkxeS_YgTut0C@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-09-27 05:38:08 Re: BUG #5679: pgAdminIII 1.12.0 hangs
Previous Message Henk Dekker 2010-09-26 23:28:21 BUG #5679: pgAdminIII 1.12.0 hangs