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

Поиск
Список
Период
Сортировка
От Oleg Serov
Тема Re: Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)
Дата
Msg-id cec7c6df0810270720x1f21ad3eoaa6156281791780b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-bugs
Ok, thanks... it is not a bug;

2008/10/27 hubert depesz lubaczewski <depesz@depesz.com>:
> 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@[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@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
>

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: BUG #4491: regression in gist indexes
Следующее
От: Alexandra Nitzschke
Дата:
Сообщение: Bug (#3484) - Missing pg_clog/0AE6