On Tue, Mar 15, 2016 at 2:48 PM, drum.lu...@gmail.com <drum.lu...@gmail.com> wrote:
> > >>>> >>> I wouldn't ask if I wouldn't have tested it! >>> >>> Will have a look. >>> >>> >> I didn't asked if you tested what you did post. I asked if you tried >> anything else before asking to be fed the answer. If you did it would be >> nice to include those other attempts. >> >> David J. >> >> >> > > > It's already working: > >> INSERT INTO junk.wm_260_billables2 (account_id, code, info) >> SELECT account_id, 'test_' || uuid_generate_v4(), info >> FROM junk.wm_260_billables1; > > > BUT.. I'm getting a very long UUID - Would like some smaller > >> test_ea8bacbe-fa3c-4072-b511-643a56feb40e > > SELECT 'test_' || substring(uuid_generate_v4()::text, 1, 1); Or use a sequence, or just compute "ROW_NUMBER() OVER ()" and tack that on. David J.
