converting mac-adress type to string - Mailing list pgsql-novice

From Michael Cochez
Subject converting mac-adress type to string
Date
Msg-id 676690.20722.qm@web33502.mail.mud.yahoo.com
Whole thread Raw
Responses Re: converting mac-adress type to string  ("Rodrigo De León" <rdeleonp@gmail.com>)
List pgsql-novice
Hello,
I want to create a view where the mac address of a table is seen as a string i was thinking about something like this :
SELECT some_function_to_convert(mac_address) FROM table;
is this possible, and what function do i need to use?
why is it so difficult to change a view, things like changing column names/quantity
 seem to be impossible??

Michael Cochez


Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Null records in pg_operator
Next
From: "Rodrigo De León"
Date:
Subject: Re: converting mac-adress type to string