| From: | "Mayers, Philip J" <p(dot)mayers(at)ic(dot)ac(dot)uk> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | LIKE with macaddr types |
| Date: | 2000-12-12 11:45:53 |
| Message-ID: | A0F836836670D41183A800508BAF190B35E240@icex1.cc.ic.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 |
+----------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vilson farias | 2000-12-12 11:51:30 | postgresql-server-7.0.3-2.i386.rpm error |
| Previous Message | Roger Wernersson | 2000-12-12 11:04:46 | RE: Re: Unanswered questions about Postgre |