and another sql question...
greatly simplified info:
i want to display all sns where there is not a single
instance of inspect_pass = t
iow, a sn may have 1 inspection - t or 4 inspections -
f, f, f, t or any number of inspections as long as
they are 1. all f or 2. they are f up until the final
in php, i'd run a select where inspect_pass = true and
test to see if the recordset contained a value or not.
in this case, it is required that sql itself generate
the correct result, if possible.
my app actually has about 6 distinct test areas, each
requiring this test, but i thought i'd KISS it so the
request is clear. eventually, i will want to test
that all prior inspections ended in t before allowing
the user to input the current inspection...
app minutae can wear a guy down!
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
pgsql-novice by date
|Next:||From: me||Date: 2006-01-07 00:28:07|
|Subject: primary key on lower(varchar)|
|Previous:||From: Andrew Chambers||Date: 2006-01-06 20:04:01|
|Subject: Re: Problem when trying to compile and link program on Windows to libpq|