ERROR: missing "LOOP" at end of SQL expression

Question

I'm getting the above error in my code, which indicates the 'while' line. I'm trying to find the number of intersection points to a line on some gis data. I've copied the code verbatim, the postgis code shouldn't affect the problem. (And if I'm trying to do this in a really stupid way, please say. I'm only a beginner)

create or replace function border() returns table(x real, sum bigint) as $$
declare x real;
begin   
    x := -35.5724;
    while x > -36.4 do
        return query select x,sum(st_npoints(st_intersection(the_geom,st_setsrid(st_makeline(st_point(173.3,x),st_point(175,x)),4167)))) from auckland_numberlines;
        x := x - 0.1;
    end while
end
$$ language plpgsql;

Satya · Accepted Answer · 2013-12-02 05:38:49Z

1

 while x > -36.4 do
    return query select x,sum(st_npoints(st_intersection(the_geom,st_setsrid(st_makeline(st_point(173.3,x),st_point(175,x)),4167)))) from auckland_numberlines;
        x := x - 0.1;    
    end while

should be

WHILE x > -36.4 LOOP
    return query select x,sum(st_npoints(st_intersection(the_geom,st_setsrid(st_makeline(st_point(173.3,x),st_point(175,x)),4167)))) from auckland_numberlines;
        x := x - 0.1;
END LOOP ;

answered Dec 2, 2013 at 5:38

Satya

8,9016 gold badges41 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ERROR: missing "LOOP" at end of SQL expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related