Re: [GENERAL] PL/PgSQL Boolean Comparison Operator Binding

2005-01-15 Thread Thomas F . O'Connell
Never mind. I think I had some data that hadn't been calibrated lying around prior to testing. I think my test case was flawed. Sorry for the noise. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37

[GENERAL] PL/PgSQL Boolean Comparison Operator Binding

2005-01-15 Thread Thomas F . O'Connell
I was recently testing some logic based on columns of type boolean and noticed some unintuitive behavior in PL/PgSQL. I had a construct like the following: IF NOT col1 AND NOT col2 THEN ... In a scenario where both col1 and col2 were false, this condition was not triggered. If I rewrote it as: