pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mourad EL HADJ MIMOUNE <mimoune@ensma.fr>
To: pgsql-sql@postgresql.org
Subject: INSERT value of type table
Date: Fri, 25 May 2001 10:29:28 +0200
Message-ID: <002501c0e4f4$d053cd40$71a337c1@ensma.fr> (raw)
References: <200105242320.f4ONKTA75941@postgresql.org>

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
>




view thread (2+ messages)  latest in thread

Message-ID: <002501c0e4f4$d053cd40$71a337c1@ensma.fr>
Permalink:  ../002501c0e4f4$d053cd40$71a337c1@ensma.fr/
Also on:    postgresql.org/message-id/002501c0e4f4$d053cd40$71a337c1@ensma.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mimoune@ensma.fr
  Subject: Re: INSERT value of type table
  In-Reply-To: <002501c0e4f4$d053cd40$71a337c1@ensma.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox