Hi Alban
Probably no difference except I have four cases and I was trying, in an
attempt to save processing time, to compact commands a little.
Bob
-----Original Message-----
From: Alban Hertroys
Sent: Tuesday, August 07, 2012 3:40 PM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Using Insert with case
On 8 Aug 2012, at 24:26, Bob Pawley wrote:
Hi
select
case when somevariable = 2
then (insert into pipe (line)
select bob.edge_data.edge_id
from bob.edge_data, bob.node, pipe
where st_intersects(st_startpoint(bob.edge_data.geom),
bob.node.geom)
and bob.node.node_id = 415
and pipe.id = 1)
I am attempting to use the above. However, with or without the enclosing
brackets I get a syntax error on the word into.
Is that somehow different from this?
insert into pipe (line)
select bob.edge_data.edge_id
from bob.edge_data, bob.node, pipe
where st_intersects(st_startpoint(bob.edge_data.geom),
bob.node.geom)
and bob.node.node_id = 415
and pipe.id = 1
and somevariable = 2
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
