LIKE with macaddr types - Mailing list pgsql-general

From Mayers, Philip J
Subject LIKE with macaddr types
Date
Msg-id A0F836836670D41183A800508BAF190B35E240@icex1.cc.ic.ac.uk
Whole thread Raw
List pgsql-general
All,

I want to do a LIKE on a column of type macaddr, looking (for example) for
all MAC addresses with the prefix "00:80", and so on. There's no ~~ operator
for macaddr though... I tried casting macaddr to text, but that's undefined
apparently (WTF?) - any ideas?

Regards,
Phil

+----------------------------------+
| Phil Mayers, Network Support     |
| Centre for Computing Services    |
| Imperial College                 |
+----------------------------------+

pgsql-general by date:

Previous
From: Roger Wernersson
Date:
Subject: RE: Re: Unanswered questions about Postgre
Next
From: "Vilson farias"
Date:
Subject: postgresql-server-7.0.3-2.i386.rpm error