Re: INSERT with SELECT not working in pgAdmin

From: Stefan Wild <wilds81(at)yahoo(dot)de>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT with SELECT not working in pgAdmin
Date: 2010-09-21 18:50:35
Message-ID: 227547.73029.qm@web26708.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok I found the solution. I have to use the UPDATE command and not the INSERT:

UPDATE c_transactions SET timestamp = entrytimestamp

and than:

UPDATE c_transactions SET timestamp = exittimestamp WHERE exittimestamp IS NOT NULL

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-09-21 18:53:17 Re: INSERT with SELECT not working in pgAdmin
Previous Message Peter Hopfgartner 2010-09-21 18:31:45 Re: Getting FATAL: terminating connection due to administrator command