Re: BUG #12202: json operator ->>with offset

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: matt(at)nonuby(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12202: json operator ->>with offset
Date: 2014-12-11 17:34:48
Message-ID: 20141211173448.GK1768@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

matt(at)nonuby(dot)com wrote:

> I am just going to link to the stackoverflow post, as it contains both the
> question and an answer which helps clarify the problem, I fear pasting as-is
> here might be confusing.
>
> http://stackoverflow.com/questions/27415340/postgresql-offset-behavior-with-json-column?noredirect=1#comment43279635_27415340
>
> tl;dr When using offset, postgres seems to want to unserialize the json data
> for every row it's visiting.

Please don't tl;dr bug reports. Paste the contents here. We're not in
love with links to external sites.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matt Freeman 2014-12-11 18:17:51 Re: BUG #12202: json operator ->>with offset
Previous Message Alvaro Herrera 2014-12-11 17:32:37 Re: BUG #12204: Getting wrong results from full text search