BUG #8218: Error when querying an JSON data, 9.3beta

Поиск
Список
Период
Сортировка
От daniel.zlatev@gmail.com
Тема BUG #8218: Error when querying an JSON data, 9.3beta
Дата
Msg-id E1UlhI8-0000bi-Ln@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8218: Error when querying an JSON data, 9.3beta  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8218
Logged by:          Daniel Zlatev
Email address:      daniel.zlatev@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Windows
Description:        =


Dears,

today I was playing with some JSON data, and I have noticed something
strange.

1. I've created the follwing table:
CREATE TABLE products (
    data JSON
);

2. Then inserting some data:
INSERT INTO products(data) VALUES('{"id": 1, "name": "shoes", "in_stock":
5}');
INSERT INTO products(data) VALUES('[1,2,3,4,5]');

3. Then i've run this SELECT statement
SELECT * FROM products WHERE (data->>'in_stock')::integer > 0

Output was:
[Err] ERROR: cannot extract field from a non-object

I can understand the reason behind this error(JSON array don't has fields),
but for me it is very logical postgres to exclude this row from the
returning set, rather to throw an error.

So that is it.

Best regards
Daniel

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

Предыдущее
От: Isaac Morland
Дата:
Сообщение: Re: BUG #8215: pg_dump includes table out of order in SQL dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8218: Error when querying an JSON data, 9.3beta