> The type of macaddr column could not work "Like" pattern matches.
Like is for comparing texts, so convert to text? > mac_test=# select * from addr where mac like '%2e'; maybe try something like: SELECT * FROM addr WHERE mac::TEXT LIKE '%2E'; Hope this help, have a nice day, -- Fabien Coelho - [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])