> 3. select into destinationtable from temptable where
> temptable.primarykey not exists
> ( select destinationtable.primarykey
> from destination table
thanks for the lead...
select product_number, product_name,
product_entry_date --into t_product
where not exists
( select product_number
where t_temp.product_number =
i did have to add a where clause in the subselect to
get what i was after.
"select into" appears to work only with a new table.
iow i can't select into t_product since it already
that leaves me needing to combine t_products and
ps - maybe select into can work with existing tables,
but i don't know how.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-06-24 00:03:50|
|Subject: Re: Copy Data Question |
|Previous:||From: operationsengineer1||Date: 2006-06-23 22:52:22|
|Subject: Re: Copy Data Question - SOLVED|