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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Steve Clark Sent: Thursday, June 2, 2016 9:56 AM To: pgsql <pgsql-general@xxxxxxxxxxxxxx> Subject: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
