Re: UUID datatype

This I got, need some implicit way, like maybe in RULE on SELECT can we
write this ?

Thanks
Sridhar
OpenText

On Mon, May 30, 2016 at 1:05 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> 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
>