Re: potential bug in JSON

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: potential bug in JSON
Дата
Msg-id CAFjNrYt25WG2jgTBrVYGkLP4r+sEQA+PZ7xqG8cKPpoOb2OMtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: potential bug in JSON  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On 28 May 2013 17:53, Josh Berkus <josh@agliodbs.com> wrote:
On 05/28/2013 08:38 AM, Szymon Guz wrote:
> I've found a potential bug. Why the "->" operator returns JSON instead of
> TEXT? It doesn't make sens for me, and the documentation doesn't inform
> about that.

Yes, it most certainly does:
http://www.postgresql.org/docs/9.3/static/functions-json.html

If you want to get text, use the ->> operator.



Yea, I noticed that. It was a little bit misleading for me that "->" is for getting field and "->>" is for getting field as text. Especially when "->"::TEXT doesn't return the same value as "->>".
Maybe there should be added "as JSON" to those operators which don't return text?

Szymon

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Planning incompatibilities for Postgres 10.0
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: Extent Locks