Re: converting mac-adress type to string

["Rodrigo De León" <rdeleonp(at)gmail(dot)com>]

On 9/20/07, Michael Cochez <michaelcochez(at)yahoo(dot)com> wrote:
> 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?

SELECT mac_address::text FROM table;