i'm new to postgresql i tried to create the following database but i keep getting this error when creating the table "HOTEL" :ERROR: syntax error at or near "position"
LINE 4: positions position,
and i would like also to know how to querying this table ,thanks.
create type adresse as (
numRue INTEGER,
NomRue VARCHAR(30),
Ville VARCHAR(30));
create type position as(
latitude REAL ,
longitude REAL);
create type chambre as(
numChambre INTEGER ,
typeChambre VARCHAR(30),
prix REAL);
create table hotel (
nom VARCHAR(30),
Adresse adresse,
positions position,
Chambres chambre,
nbPersonnel INTEGER,
nbEtoile INTEGER,
telephone VARCHAR(14));