Using Insert with case

Поиск
Список
Период
Сортировка
От Bob Pawley
Тема Using Insert with case
Дата
Msg-id 5ACA3D3C33874B49A0D9A773C5488FF9@BobPC
обсуждение
Ответы Re: Using Insert with case
Re: Using Insert with case
Re: Using Insert with case
Список pgsql-general
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.
 
Help will be appreciated.
 
Bob

В списке pgsql-general по дате отправления: