On 3/15/2016 2:48 PM, drum.lu...@gmail.com wrote:
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
that would be a v4 uuid, like you asked for in the above code.
test=# select uuid_generate_v4();
uuid_generate_v4
--------------------------------------
09b24e5b-5116-435e-94b9-f0da4661f594
afaik, all UUID's are 128 bit numbers expressed in hexadecimal in that
format. This is an ISO standard.
--
john r pierce, recycling bits in santa cruz
