Where with NOT

[matthaught]

I am trying to put together a select query for a search function I am working on. I am trying to allow AND/OR/NOT to help limit the results but I can't get NOT to work in the where clause. Here is a output sample:

SELECT company,customerid,compcontact
FROM customers
WHERE (company ~ '.Jen.' OR compcontact ~ '.Jen.')
NOT (company ~ '.Matt.' OR compcontact ~ '.Matt.')
ORDER BY company ASC

The NOT between the ()() is where i get the error of <i>ERROR: parser: parse error at or near "("</i> but AND and OR works. What am I missing here?

Matt

[matthaught]

Oh I forgot, I am using PostgreSQL 7.1

Matt

[[deleted]]

What you're missing is the SQL syntax guide of the Postgres manual.
NOT by itself only inverts a boolean value, you have to tell PostgreSQL what to do with that value.