Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uz6Ep-0000ld-9I for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2013 14:28:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uz6Eo-0004Ix-OS for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2013 14:28:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uz6En-0004HR-5t for pgsql-sql@postgresql.org; Tue, 16 Jul 2013 14:28:21 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uz6Ek-0004S4-DY for pgsql-sql@postgresql.org; Tue, 16 Jul 2013 14:28:20 +0000 Received: from [192.168.1.37] ([115.84.90.134]) by mail.gmx.com (mrgmx003) with ESMTPSA (Nemesis) id 0MK0ur-1UxjJh3RmH-001TmH; Tue, 16 Jul 2013 16:27:50 +0200 Message-ID: <51E55861.5000606@gmx.de> Date: Tue, 16 Jul 2013 21:27:45 +0700 From: Stefan Sylla User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130623 Thunderbird/17.0.7 MIME-Version: 1.0 To: Igor Neyman CC: "pgsql-sql@postgresql.org" Subject: Re: SOLVED: update column based on postgis query on anther table References: <51E4B5A5.4040805@gmx.de> <317.1373952273@sss.pgh.pa.us> <1373961468438-5763904.post@n5.nabble.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:9KxsqphHBk7L2hLADCcOlpQ6kVDC33HPeTOwZLOYCboxYbRO3yk AUXlVh4fV31kXBJkekCG3qpaqOYEdYk7WEa6io3twdB8xuVTNJHLenCv/3RqRTccicb4IXN s3duOVflZiScye8603WaUgW7fy8MXS0TETKgvpKSTR31+bE5tMruACLP1Doyu5mIMe/4JbD rHy/7vit8Z99k2HNHYnEQ== X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Hi Igor, thank you so much, the trigger function that you provided is exactly what I was looking for. I already read/heard about the SELECT INTO statement but I never actually understood what it is needed for. Here I go ;-) Stefan -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql