Greetings Pg folks,
I have a database schema (not mine) that uses bytea to represent a MAC address. I'd like to create a view that casts that field into a MACADDR type.
# \d lease4
Table "public.lease4"
Column │ Type │ Collation │ Nullable │ Default
════════════════╪══════════════════════════╪═══════════╪══════════╪═════════
hwaddr │ bytea │ │ │
# select hwaddr from lease4;
hwaddr
════════════════
\x9cebe803e3b9
It looks like I can cast the bytea to text and then manipulate that and finally cast it to macaddr.
Is there a better, or more canonical, way to convert/cast this field?
Thanks for any help!
-m