> 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,
--
Fab
The following bug has been logged online:
Bug reference: 1223
Logged by: Shigeaki Momose
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.2
Operating system: Linux
Description:RedHat Linux 8
Details:
The type of macaddr column could not work "Like" patt
