Re: converting mac-adress type to string

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Michael Cochez" <michaelcochez(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: converting mac-adress type to string
Date: 2007-09-20 16:45:32
Message-ID: a55915760709200945v6067a1b7g2895ffe2a77f1a72@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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;

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Cochez 2007-09-20 18:25:28 selecting other schema's as the public one from php
Previous Message Michael Cochez 2007-09-20 15:35:13 converting mac-adress type to string