Skip site navigation (1) Skip section navigation (2)

Re: Insert using a subselect?

From: A_Schnabel(at)t-online(dot)de (Andre Schnabel)
To: "Pgsql Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Insert using a subselect?
Date: 2001-09-13 18:25:24
Message-ID: 001a01c13c81$74f14060$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
----- Original Message ----- 
From: "Francisco Reyes" <lists(at)natserv(dot)com>
Subject: Re: [NOVICE] Insert using a subselect?

> so it is not possible to populate an insert from a subselect if there is
> more than one row/column?

Of course, it is.
But you should just either use he keyword "values" or use a select.

The right statement is:
insert into hearn_dates (date) 
select distinct merge_date from hearn;

For further details have a look at the iDoc's


In response to

pgsql-novice by date

Next:From: Sykora, DaleDate: 2001-09-14 00:33:27
Subject: [novice] problem
Previous:From: Francisco ReyesDate: 2001-09-13 17:27:52
Subject: Re: Path for pgsql \i option?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group