From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Steve Clark <steve(dot)clark(at)netwolves(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dumb question |
Date: | 2016-06-02 17:23:52 |
Message-ID: | CAEfWYyxZ78N1o-D66OoYvFYMHOyq5iEA2o-nTdv1m=UFGc4-dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Something like:
select max(id) from yourtable where sts=0 and ref_id is null;
That assumes that ref_id is null. It would help to see your table structure
and the query you tried that doesn't work. If ref_id is actually a
character string then you might need ref_id='' or coalesce(ref_id,'')='' if
it can be null or empty string.
Cheers,
Steve
On Thu, Jun 2, 2016 at 10:16 AM, Steve Clark <steve(dot)clark(at)netwolves(dot)com>
wrote:
> 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
>
> --
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bit Divine | 2016-06-02 17:31:37 | Refresh materialized views recursively |
Previous Message | David G. Johnston | 2016-06-02 17:23:20 | Re: dumb question |