Re: BUG #12202: json operator ->>with offset - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #12202: json operator ->>with offset
Date
Msg-id 20141211173448.GK1768@alvh.no-ip.org
Whole thread Raw
In response to BUG #12202: json operator ->>with offset  (matt@nonuby.com)
Responses Re: BUG #12202: json operator ->>with offset
List pgsql-bugs
matt@nonuby.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #12204: Getting wrong results from full text search
Next
From: Tom Lane
Date:
Subject: Re: BUG #12204: Getting wrong results from full text search