1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| CREATE SEQUENCE test_seq START WITH 0 MINVALUE 0 INCREMENT BY 1 MAXVALUE 999999999;
SELECT Id, TestField
FROM
(SELECT setval('test_seq', 0)) INIT,
(
SELECT nextval('test_seq') AS Id, 'foobar' AS TestField
UNION ALL
SELECT nextval('test_seq'), libelle FROM Region
UNION ALL
SELECT nextval('test_seq'), 'foobar'
) V;
Id;TestField
1;"foobar"
2;"Alsace"
3;"Aquitaine"
4;"Auvergne"
5;"Basse-Normandie"
6;"Bourgogne"
7;"Bretagne"
8;"Centre"
9;"Champagne-Ardenne"
10;"Corse"
11;"Franche-Comté"
12;"Haute-Normandie"
13;"Ile-De-France"
14;"Languedoc-Roussillon"
15;"Limousin"
16;"Lorraine"
17;"Midi-Pyrénées"
18;"Nord-Pas-De-Calais"
19;"Pays-De-La-Loire"
20;"Picardie"
21;"Poitou-Charentes"
22;"Provence-Alpes-Côte-D'Azur"
23;"Rhône-Alpes"
24;"Outre-Mer"
25;"foobar" |
Partager