Re: overwrite column data select - Postgres 9.2

[Patrick B <patrickbakerbr@xxxxxxxxx>]

Rather than test.UID.@xxxxxxxxxxx I was hoping for values such as:

test.4645364.@example.com

test.8786756.@example.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''