> 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])

Reply via email to