Re: Moving from MySQL to PGSQL....some questions (multilevel

Yes I know,

But how you do this at PgSQL????


scott.marlowe wrote:

>On Tue, 2 Mar 2004, [UTF-8] Paulovič Michal wrote:
>
>
>
>>how you solve the problem with multilevel autoicrement?
>>
>>In MySQL you create table with col1, col2. Col 2 is AUTOICREMENT and you
>>have to create UNIQUE INDEX (Col1, Col2). If you insert to this table
>>for col1 volume 1, col2 automaticaly increase by one.
>>
>>Example:
>>Insert into table values (1);
>>Insert into table values (1);
>>Insert into table values (2);
>>Insert into table values (1);
>>Insert into table values (2);
>>
>>
>
>I did this in MySQL and got this:
>
>create table test (id1 int, id2 int auto_increment, primary key(id2));
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> alter table test add unique index (id1, id2);
>Query OK, 0 rows affected (0.09 sec)
>Records: 0  Duplicates: 0  Warnings: 0
>
>mysql> insert into test (id1) values (1);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> insert into test (id1) values (1);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> insert into test (id1) values (2);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> insert into test (id1) values (1);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> insert into test (id1) values (2);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> select * from test;
>+------+-----+
>| id1  | id2 |
>+------+-----+
>|    1 |   1 |
>|    1 |   2 |
>|    1 |   4 |
>|    2 |   3 |
>|    2 |   5 |
>+------+-----+
>5 rows in set (0.00 sec)
>
>I'm running an older flavor of 3.23.41, it's what came with RH 7.2
>
>Or did I do something different?
>
>
>>Result is:
>>1,1
>>1,2
>>2,1
>>1,3
>>2,2
>>
>>How you convert this functionality from MySQL to PgSQL???
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>________ Information from NOD32 ________
>This message was checked by NOD32 Antivirus System for Linux Mail Server.
>http://www.nod32.com
>
>
>