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
>