how to duplicate data for few times by SQL command in PG

Поиск
Список
Период
Сортировка
От tsunghan hsieh
Тема how to duplicate data for few times by SQL command in PG
Дата
Msg-id CAFypHLy=TU63JJJFofETUP_T8Dg3G7b6WZN0DR=R-Cmnvgvmpg@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to duplicate data for few times by SQL command in PG  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
Дерево обсуждения
Hi

I have a table which just has one column as following in Original Table. I wanna duplicate all of data for few times and with same order as following in New Table. Is there anyone who can help me? Thanks

Han

Original Table
23
45
65
22

New Table
23
23
23
45
45
45
65
65
65
65
22
22
22
22

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

Предыдущее
От: "Felix Kunde"
Дата:
Сообщение: Re: Getting a delta of two json-typed objects? (a breeze w/ hstore)
Следующее
От: agent
Дата:
Сообщение: Re: BDR Error restarted