Re: UUID datatype

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: UUID datatype
Date: 2016-05-30 07:35:49
Message-ID: CAB7nPqRuYw1AAJRPUysC6DPXN8F+GqkM9jX3ZqG5Pgh60AwpYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 30, 2016 at 4:25 PM, Sridhar N Bamandlapally
<sridhar(dot)bn1(at)gmail(dot)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

In response to

  • UUID datatype at 2016-05-30 07:25:19 from Sridhar N Bamandlapally

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CN 2016-05-30 09:15:57 How to find business partners from PostgreSQL communities?
Previous Message Sridhar N Bamandlapally 2016-05-30 07:25:19 UUID datatype