Re: Unique UUID value - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Unique UUID value - PostgreSQL 9.2
Дата
Msg-id CAKFQuwY1OJs8ySHZkgPiYdibrM6tN5iy8GSOjymW5ki7x4DnLA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unique UUID value - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Ответы Re: Unique UUID value - PostgreSQL 9.2
Список pgsql-general
Дерево обсуждения
On Tue, Mar 15, 2016 at 2:48 PM, drum.lucas@gmail.com <drum.lucas@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.
​

В списке pgsql-general по дате отправления: