pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stefan Sylla <stefansylla@gmx.de>
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: SOLVED: update column based on postgis query on anther table
Date: Tue, 16 Jul 2013 21:27:45 +0700
Message-ID: <51E55861.5000606@gmx.de> (raw)
In-Reply-To: <A76B25F2823E954C9E45E32FA49D70EC1BBEBE2A@mail.corp.perceptron.com>
References: <51E4B5A5.4040805@gmx.de>
	<317.1373952273@sss.pgh.pa.us>
	<1373961468438-5763904.post@n5.nabble.com>
	<A76B25F2823E954C9E45E32FA49D70EC1BBEBE2A@mail.corp.perceptron.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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



Message-ID: <51E55861.5000606@gmx.de>
Permalink:  ../51E55861.5000606@gmx.de/
Also on:    postgresql.org/message-id/51E55861.5000606@gmx.de

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: stefansylla@gmx.de, ineyman@perceptron.com
  Subject: Re: SOLVED: update column based on postgis query on anther table
  In-Reply-To: <51E55861.5000606@gmx.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox