Re: [SQL] Foreign Key: what value? -- currval()

A. Kretschmer wrote: > Davi Leal folgendes: > > Hi, > > How to know the value which I must set in the foreign key field?. I have > > two tables: > > > > > > CREATE TABLE AA ( > > Id SERIAL PRIMARY KEY, > > data char(9) > >

[SQL] Foreign Key: what value?

Hi, How to know the value which I must set in the foreign key field?. I have two tables: CREATE TABLE AA ( Id SERIAL PRIMARY KEY, data char(9) ); CREATE TABLE BB ( BB_Id integer REFERENCES AA(Id) NOT NULL, field char(5) ); I insert a register on table AA, IN