----- Original Message -----
From: "Francisco Reyes" <lists@natserv.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
http://www.postgresql.org/idocs/index.php?sql-insert.html
Andre