'AND' in WHERE clauses - Mailing list pgsql-novice

From James David Smith
Subject 'AND' in WHERE clauses
Date
Msg-id CAMu32AA=khbhaD-GOCd9Myy--_-uCdb8iOCVtX=3Md_LJ9+bAg@mail.gmail.com
Whole thread Raw
Responses Re: 'AND' in WHERE clauses  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-novice
Hi all,

Sometimes I get a bit confused with my AND and OR clauses in WHERE statements. When I'm working with big data I often think it's done one thing and find later it's done another. Given this, would someone just glance at this for me please?  Will this only set the_geom in the condition that ALL of my WHERE clauses are satisfied?  ( I hope so)

UPDATE stage SET the_geom = st_setsrid(st_makeline(st_makepoint(soose::integer, soosn::integer), st_makepoint(sdose::integer, sdosn::integer)),27700) WHERE sdurn::numeric = 0 AND bad_flag IS NULL AND smode5y = '1'  AND st_length(st_makeline(st_makepoint(soose::integer, soosn::integer), st_makepoint(sdose::integer, sdosn::integer))) < 60;

Thanks

James

pgsql-novice by date:

Previous
From: Rohit Goyal
Date:
Subject: How to allocate space to structure instance
Next
From: Albe Laurenz
Date:
Subject: Re: 'AND' in WHERE clauses