Re: overwrite column data select - Postgres 9.2

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>
Cc: "Steve Petrie, P(dot)Eng(dot)" <apetrie(at)aspetrie(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: overwrite column data select - Postgres 9.2
Date: 2016-09-21 23:57:10
Message-ID: CAJNY3ivVGbNLOSfcrM08=Z1NTv_S7O=Owea_yNwk-fmu0eaH3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Rather than test(dot)UID(dot)(at)example(dot)com <test(dot)UID(dot)(at)tikcha(dot)com> I was hoping for
> values such as:
>
> test.4645364.@ <test(dot)4645364(dot)(at)tikcha(dot)com>example.com
> <test(dot)UID(dot)(at)tikcha(dot)com>
>
> test.8786756.@ <test(dot)8786756(dot)(at)tikcha(dot)com>example.com
> <test(dot)UID(dot)(at)tikcha(dot)com>
>
>
> With UNIQUE UUID
>
>
> is that possible?
>
>
>
I was able to do that using:

SELECT cast(''test.''|| uuid_generate_v1() AS varchar(30)) || ''@example.com
''

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-09-22 00:41:04 Re: json select question
Previous Message CS DBA 2016-09-21 23:54:01 json select question