From: | Steve Clark <steve(dot)clark(at)netwolves(dot)com> |
---|---|
To: | Dann Corbit <DCorbit(at)connx(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dumb question |
Date: | 2016-06-02 20:13:34 |
Message-ID: | df7dfe37-aaa3-765b-d1e8-b954d1cf9107@netwolves.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/02/2016 04:07 PM, Dann Corbit wrote:
> This is your request, translated directly into SQL
>
> select max(id) from sometable where sts=0 and ref_id IS NULL
>
> Looking at your sample, it seems that sts is always 1 when ref_id exists, so it may possibly simplify to:
>
> select max(id) from sometable where sts=0
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Steve Clark
> Sent: Thursday, June 2, 2016 9:56 AM
> To: pgsql <pgsql-general(at)postgresql(dot)org>
> Subject: [GENERAL] dumb question
>
> Hi List,
>
> I am a noob trying to do something that seems like it should be easy but I can't figure it out.
>
> I have a table like so:
>
> id | ref_id | sts
> ------------------
> 1 | | 0
> 2 | 1 | 1
> 3 | | 0
> 4 | | 0
> 5 | 4 | 1
> 6 | | 0
> 7 | 6 | 1
>
> I want to find the max(id) whose sts is 0 but whose id is not referenced by ref_id.
>
> so the answer would be id=3.
>
> Thanks for any pointers,
> Steve
>
Hi Dan,
Thanks for the response - but I think that would give me id=6 and not id=3.
--
Stephen Clark
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-06-02 20:16:13 | Re: dumb question |
Previous Message | Dann Corbit | 2016-06-02 20:11:49 | Re: dumb question |