| From: | Dani <danielcheagle(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial? |
| Date: | 2018-01-07 06:17:29 |
| Message-ID: | CAEXvJLfO6-=6jBe+kdSV3eOV4SACttkqYu9A59qjqKE_MBk6-Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi! All!
I Need create a one decimal serial column or simulate it with multiple
columns of bigint.
gaps don't are problem.
pseudo-code:
create table bank (
id0 decimal( 500, 0) not null auto-increment,
etc text
)
or
create table bank (
id0 bigint not null,
id1 bigint not null,
id2 bigint not null,
idn bigint not null,
etc text
primary key(id0, id1, id2, idn),
auto_increment(id0, id1, id2, idn)
)
How a example of behavior (using a range of 1 .. 3)
insert into bank(etc) Values "3*3*3 times 'Thanks'";
select * from bank;
id0 id1 id2 idn text
1 1 1 1 T
1 1 1 2 T
1 1 1 3 T
1 1 2 1 T
1 1 2 2 T
1 1 2 3 T
1 1 3 1 T
1 1 3 2 T
1 1 3 3 T
1 2 1 1 T
etc.
Thanks So Much!!!!
[]'s Dani. :-)
--
"There are many plans in the Human heart, But
is the Lord's Purpose that prevails"
"Existem Muitos planos e desejos no coração Humano, MAS
são os Propósitos do Senhor que prevalecem"
[]'s Dani:-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2018-01-07 08:27:21 | Re: ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial? |
| Previous Message | Alvaro Herrera | 2018-01-04 21:05:27 | Re: Tablespaces |