Skip site navigation (1) Skip section navigation (2)

Re: Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (textfield is boolean?)

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Oleg Serov <serovov(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (textfield is boolean?)
Date: 2008-10-27 14:14:46
Message-ID: 20081027141446.GA29664@depesz.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Oct 27, 2008 at 05:08:35PM +0300, Oleg Serov wrote:
> I can't get hstore value by key. i have very interesting error

the problem is that -> has very low priority, but you work with it
anyway:
# select tconvert('a', 'b')->'a' is null;
ERROR:  operator does not exist: hstore -> boolean
LINE 1: select tconvert('a', 'b')->'a' is null;
                                 ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
(depesz(at)[local]:5840) 15:14:03 [depesz]
# select (tconvert('a', 'b')->'a') is null;
 ?column?
----------
 f
(1 row)

depesz

-- 
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

pgsql-bugs by date

Next:From: Teodor SigaevDate: 2008-10-27 14:15:40
Subject: Re: BUG #4491: regression in gist indexes
Previous:From: Oleg SerovDate: 2008-10-27 14:08:35
Subject: Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group