On Wed, Feb 16, 2011 at 12:33 AM, Simon Slavin slav...@bigfraud.org wrote:
Or to put it another way, if a column is autoincrement and you don't intend
to mess with the values manually, it's going to be unique anyway, so it makes
a good simple short primary key. You may have good reasons to
Quoth Maciej Lotkowski maciej.lotkow...@gmail.com, on 2011-02-16 09:45:45
+0100:
It's not about the real use case. I understand, that having such a
primary key probably doesn't make much sense. I'm asking if it is
technically possible to create a table like
create table foo (
id integer
Hi
Is it possible to have composite primary key where one column is
autoincrement? From what I found in docs it looks like it is possible
to have either simple primary key on one autoincrement column or
composite PK on few columns without autoincrement. Am I right? If no,
what is the syntax to
Quoth Maciej Lotkowski maciej.lotkow...@gmail.com, on 2011-02-15 23:28:01
+0100:
Is it possible to have composite primary key where one column is
autoincrement? From what I found in docs it looks like it is possible
to have either simple primary key on one autoincrement column or
composite PK
On 15 Feb 2011, at 11:28pm, Drake Wilson wrote:
Quoth Maciej Lotkowski maciej.lotkow...@gmail.com, on 2011-02-15 23:28:01
+0100:
Is it possible to have composite primary key where one column is
autoincrement? From what I found in docs it looks like it is possible
to have either simple