Hello.
Each user has a lot of guests. Each guest only has one user.
1. I create a table users:
CREATE TABLE users (
user_id SERIAL PRIMARY KEY,
name varchar(256)
);
2. I create a table guests:
CREATE TABLE guests (
user_id integer,
guest_id SERIAL,
PRIMARY KEY (user_id, guest_id),
FOREI
Hello.
A table has two primary keys: CREATE TABLE example ( pk1 integer, pk2
integer, PRIMARY KEY (pk1, pk2) ). To add a new record I use command:
INSERT INTO example (pk1, pk2) VALUES (0, 0). Before adding the new
record I have to find out the last value of pk2. How can I use something
like t
