INSERT value of type table
| От | Mourad EL HADJ MIMOUNE |
|---|---|
| Тема | INSERT value of type table |
| Дата | |
| Msg-id | 002501c0e4f4$d053cd40$71a337c1@ensma.fr обсуждение исходный текст |
| Список | pgsql-sql |
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 >
В списке pgsql-sql по дате отправления: