I would like to create a nested statement but am unsure of the correct syntax. My statement shoudl read someting like
SELECT field1, field2 FROM table WHERE name ILIKE xxx AND ( street ILIKE xxxx or street2 ILIKE xxxx) so basically it needs to match name and either street or street 2.. any help woudl be greatly appreciated. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
