----- 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, Dale||Date: 2001-09-14 00:33:27|
|Subject: [novice] pg_regress.sh problem|
|Previous:||From: Francisco Reyes||Date: 2001-09-13 17:27:52|
|Subject: Re: Path for pgsql \i option?|