Re: 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.