Re: UUID datatype - Mailing list pgsql-general

From Michael Paquier
Subject Re: UUID datatype
Date
Msg-id CAB7nPqRuYw1AAJRPUysC6DPXN8F+GqkM9jX3ZqG5Pgh60AwpYg@mail.gmail.com
Whole thread Raw
In response to UUID datatype  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: UUID datatype  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-general
On Mon, May 30, 2016 at 4:25 PM, Sridhar N Bamandlapally
<sridhar.bn1@gmail.com> wrote:
> Hi
>
> Is there a way to implicit SELECT on UUID datatype in uppercase ?

You could always cast an UUID back to text and use that with upper(),
though you are not explaining what you are tying to achieve:
=# select upper(gen_random_uuid()::text);

                                                                 upper
--------------------------------------
 057A3BC2-0E62-4D68-B01A-C44D20F91450
(1 row)
--
Michael


pgsql-general by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: UUID datatype
Next
From: CN
Date:
Subject: How to find business partners from PostgreSQL communities?