> > Rather than test.u...@example.com <test.u...@tikcha.com> I was hoping for > values such as: > > test.4645364.@ <test.46453...@tikcha.com>example.com > <test.u...@tikcha.com> > > test.8786756.@ <test.87867...@tikcha.com>example.com > <test.u...@tikcha.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 ''