Re: Unique UUID value - PostgreSQL 9.2

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Mar 15, 2016 at 2:48 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> 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.

​