can anyone do a example for me.. an explain how it works?

Thanks a lot


2008/3/29, Berend Tober <[EMAIL PROTECTED]>:
>
> x asasaxax wrote:
> >    I have the following table    create table product(cod serial,
> user_cod
> > bigint, constraint product_fk Foreign Key(user_cod) references
> user(cod),
> > constraint product_pk Primary Key(cod, user_cod));
> >
> > What i want to happend is that:
> > user_cod            cod
> > 1                         1
> > 1                         2
> > 1                         3
> > 2                         1
> > 3                         1
> > 3                         2
> >
> > Can serial do that? ...
>
> No.
>
> > ...what can  i do to make this happen?
>
>
> http://archives.postgresql.org/pgsql-general/2006-08/msg00744.php
>
>
>

Reply via email to