Thread: INSERT value of type table

INSERT value of type table

From
"Mourad EL HADJ MIMOUNE"
Date:
Hi,
I want know how we can insert values in the case where the type of column is
an othor table.
exemple:
CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry
varchar);
CREATE TABLE Person (Name varchar, addr Address);
INSERT INTO addrerss VALUES ( 5, 'rue du pont',  'Lyon', 'France');
The question is :
How we can insert a new person whose address is that inserted in the
table of the addresses.

thank you for your help,

Mourad.
----- Original Message -----
From: <pgsql-sql-owner@postgresql.org>
To: <pgsql-sql@postgresql.org>
Sent: Friday, May 25, 2001 1:20 AM
Subject: Daily Digest V1 #393


> Daily Digest (mime)  -   Volume 1 : Issue 393
>
> Today's Topics:
>   where's ALTER TABLE table DROP [ COLUMN ] column???
>   Re: Recursive select
>   Stored Procedures?
>   Re: Stored Procedures?
>   Recursive select
>   photos and OID's
>   ports in use question
>   Select help
>   Re: ports in use question
>



Re: INSERT value of type table

From
"Frank Contrepois"
Date:
> exemple:
> CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry
> varchar);
> CREATE TABLE Person (Name varchar, addr Address);
> INSERT INTO addrerss VALUES ( 5, 'rue du pont',  'Lyon', 'France');
> The question is :
> How we can insert a new person whose address is that inserted in the
> table of the addresses.

CREATE TABLE Address (Number integer PRIMARY KEY, Street varchar, City
varchar, Country varchar)
CREATE TABLE Person (Name varchar, addr integer REFERENCES TO Address)

this is called a FOREIGN KEY.. look at some doc for it. this is the way
Relational DB works
bye
--
--

"L'idea di base � estremamente semplice..."
�opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)