Re: INSERT... WHERE

Hmm, nvm :-(

PostgreSQL does not yet support MERGE...

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table

2013/1/15 Serge Fonville <serge(dot)fonville(at)gmail(dot)com>

> Hi,
>
> Based on my understanding of the problem, would this be possible to solve
> with a MERGE statement?
>
> HTH
>
> Kind regards/met vriendelijke groet,
>
> Serge Fonville
>
> http://www.sergefonville.nl
>
> Convince Microsoft!
> They need to add TRUNCATE PARTITION in SQL Server
>
> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table
>
>
> 2013/1/15 Darren Duncan <darren(at)darrenduncan(dot)net>
>
>> On 2013.01.13 6:00 PM, Robert James wrote:
>>
>>> I have a lot of VALUES I want to INSERT. But only a subset of them -
>>> only those that meet a JOIN criteria involving another table.
>>>
>>> I could INSERT them into a temp table, and then do a SELECT INTO. But
>>> do I need to do that? Is there any way to do a INSERT... VALUES ...
>>> WHERE...
>>>
>>
>> As per my reply to your "Bulk INSERT with individual failure" thread, for
>> what you want to do a temporary staging table (or several) with minimal
>> constraints is truly your best option to accomplish your goal.
>>
>> Having a large amount of literals in an INSERT statement like discussed
>> is a bad idea.
>>
>> If you're loading from a file, just use some bulk load feature that
>> bypasses the need for INSERT statements, into some temp file matching the
>> format of the file.
>>
>> If you're loading from a program, use a prepared single-row INSERT
>> statement, bundling batches of say a few thousand rows at a time into a
>> single transaction.
>>
>> Then pretend your newly populated temp table was your original source,
>> but now it is visible to SQL, and you can load your regular tables from the
>> temp table(s) much more nicely.
>>
>> -- Darren Duncan
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>>
>
>