Received: from graal.ensma.fr (graal.ensma.fr [193.55.167.3]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4P8QKA83980 for ; Fri, 25 May 2001 04:26:20 -0400 (EDT) (envelope-from mimoune@ensma.fr) Received: from wallace (wallace.ensma.fr [193.55.163.113]) by graal.ensma.fr (8.9.1b+Sun/8.9.1) with SMTP id KAA23452 for ; Fri, 25 May 2001 10:25:16 +0100 (WET DST) Message-ID: <002501c0e4f4$d053cd40$71a337c1@ensma.fr> From: "Mourad EL HADJ MIMOUNE" To: References: <200105242320.f4ONKTA75941@postgresql.org> Subject: INSERT value of type table Date: Fri, 25 May 2001 10:29:28 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200105/270 X-Sequence-Number: 3098 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: To: 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 >