Skip site navigation (1) Skip section navigation (2)

converting mac-adress type to string

From: Michael Cochez <michaelcochez(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: converting mac-adress type to string
Date: 2007-09-20 15:35:13
Message-ID: 676690.20722.qm@web33502.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-novice by date

Next:From: Rodrigo De LeónDate: 2007-09-20 16:45:32
Subject: Re: converting mac-adress type to string
Previous:From: Tom LaneDate: 2007-09-20 13:59:59
Subject: Re: Null records in pg_operator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group