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.paqu...@gmail.com> wrote: > On Mon, May 30, 2016 at 4:25 PM, Sridhar N Bamandlapally > <sridhar....@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 >