Re: Explanation of tree-generating query

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Explanation of tree-generating query
Date: 2016-02-02 23:50:38
Message-ID: 56B140CE.6080600@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/2/2016 3:27 PM, Guyren Howe wrote:
> I feel like I'm pretty decent with Postgres. But I saw the following
> query on the excellent Periscope blog. I've no idea how it works, and
> the various symbols involved are difficult to look up either with
> google or in the documentation. I believe the @ sign is probably ABS,
> but the <= clause in the consequent of a when-then is something I
> haven't seen before. I'm comfortable with the rest. Can someone
> explain how this works?
>

<= is less than or equal to.

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh berkus 2016-02-03 00:16:38 Re: handling time series data
Previous Message David G. Johnston 2016-02-02 23:49:36 Re: Explanation of tree-generating query