Skip to content

Commit 68472ca

Browse files
cvvergaracvvergara
committed
removed trailing stpces from sql files
1 parent cf049ec commit 68472ca

60 files changed

Lines changed: 3315 additions & 3315 deletions

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎sql/allpairs/floydWarshall.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -28,9 +28,9 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
2828
2929
********************************************************************PGR-GNU*/
3030

31-
CREATE OR REPLACE FUNCTION pgr_floydWarshall(edges_sql TEXT, directed BOOLEAN DEFAULT TRUE,
31+
CREATE OR REPLACE FUNCTION pgr_floydWarshall(edges_sql TEXT, directed BOOLEAN DEFAULT TRUE,
3232
OUT start_vid BIGINT, OUT end_vid BIGINT, OUT agg_cost float)
3333
RETURNS SETOF RECORD AS
34-
'MODULE_PATHNAME', 'floydWarshall'
34+
'MODULE_PATHNAME', 'floydWarshall'
3535
LANGUAGE c VOLATILE;
3636

‎sql/alpha_shape/alpha_shape.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
2727
-----------------------------------------------------------------------
2828
-- Core function for alpha shape computation.
2929
-- The sql should return vertex ids and x,y values. Return ordered
30-
-- vertex ids.
30+
-- vertex ids.
3131
-----------------------------------------------------------------------
3232
CREATE OR REPLACE FUNCTION pgr_alphashape(sql text, alpha float8 DEFAULT 0, OUT x float8, OUT y float8)
3333
RETURNS SETOF record
@@ -56,7 +56,7 @@ CREATE OR REPLACE FUNCTION pgr_pointsAsPolygon(query varchar, alpha float8 DEFAU
5656
geoms := array[]::geometry[];
5757
i := 1;
5858

59-
FOR vertex_result IN EXECUTE 'SELECT x, y FROM pgr_alphashape('''|| query || ''', ' || alpha || ')'
59+
FOR vertex_result IN EXECUTE 'SELECT x, y FROM pgr_alphashape('''|| query || ''', ' || alpha || ')'
6060
LOOP
6161
x[i] = vertex_result.x;
6262
y[i] = vertex_result.y;

‎sql/astar/_astar.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,9 +5,9 @@ Generated with Template by:
55
Copyright (c) 2015 pgRouting developers
66
Mail: project@pgrouting.org
77
8-
Function's developer:
8+
Function's developer:
99
Copyright (c) 2015 Celia Virginia Vergara Castillo
10-
Mail:
10+
Mail:
1111
1212
------
1313

‎sql/astar/astar.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,9 +5,9 @@ Generated with Template by:
55
Copyright (c) 2015 pgRouting developers
66
Mail: project@pgrouting.org
77
8-
Function's developer:
8+
Function's developer:
99
Copyright (c) 2015 Celia Virginia Vergara Castillo
10-
Mail:
10+
Mail:
1111
1212
------
1313

‎sql/astar/astarCost.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,9 +5,9 @@ Generated with Template by:
55
Copyright (c) 2015 pgRouting developers
66
Mail: project@pgrouting.org
77
8-
Function's developer:
8+
Function's developer:
99
Copyright (c) 2015 Celia Virginia Vergara Castillo
10-
Mail:
10+
Mail:
1111
1212
------
1313

‎sql/common/_point_toId.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -25,11 +25,11 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
2525
/*
2626
.. function:: _pgr_pointToId(point geometry, tolerance double precision,vname text,srid integer)
2727
Using tolerance to determine if its an existing point:
28-
- Inserts a point into the vertices table "vertname" with the srid "srid",
28+
- Inserts a point into the vertices table "vertname" with the srid "srid",
2929
and returns
3030
- the id of the new point
3131
- the id of the existing point.
32-
32+
3333
Tolerance is the minimal distance between existing points and the new point to create a new point.
3434
3535
Last changes: 2013-03-22
@@ -40,7 +40,7 @@ Last changes: 2013-03-22
4040
*/
4141

4242
CREATE OR REPLACE FUNCTION _pgr_pointToId(
43-
point geometry,
43+
point geometry,
4444
tolerance double precision,
4545
vertname text,
4646
srid integer)
@@ -60,7 +60,7 @@ BEGIN
6060
|| srid ||')) AS d, id, the_geom
6161
FROM '||_pgr_quote_ident(vertname)||'
6262
WHERE ST_DWithin(
63-
the_geom,
63+
the_geom,
6464
ST_GeomFromText(
6565
ST_AsText(' || quote_literal(point::text) ||'),
6666
' || srid || '),' || tolerance||')

‎sql/common/createIndex.sql‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -28,9 +28,9 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
2828
/************************************************************************
2929
.. function:: _pgr_createIndex(tab, col,indextype)
3030
_pgr_createIndex(sname,tname,colname,indextypes)
31-
31+
3232
if the column is not indexed it creates a 'gist' index otherwise a 'btree' index
33-
Examples:
33+
Examples:
3434
* select _pgr_createIndex('tab','col','btree');
3535
* select _pgr_createIndex('myschema','mytable','col','gist');
3636
* perform 'select _pgr_createIndex('||quote_literal('tab')||','||quote_literal('col')||','||quote_literal('btree'))' ;
@@ -41,11 +41,11 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
4141
Postcondition:
4242
sname.tname.colname its indexed using the indextype
4343
44-
44+
4545
Author: Vicky Vergara <vicky_vergara@hotmail.com>>
4646
4747
HISTORY
48-
Created: 2014/JUL/28
48+
Created: 2014/JUL/28
4949
************************************************************************/
5050

5151
CREATE OR REPLACE FUNCTION _pgr_createIndex(
@@ -69,10 +69,10 @@ BEGIN
6969
perform _pgr_msg(msgKind, fnName);
7070
else
7171
if indext = 'gist' then
72-
query = 'create index '||_pgr_quote_ident(tname||'_'||colname||'_idx')||'
72+
query = 'create index '||_pgr_quote_ident(tname||'_'||colname||'_idx')||'
7373
on '||tabname||' using gist('||quote_ident(colname)||')';
7474
else
75-
query = 'create index '||_pgr_quote_ident(tname||'_'||colname||'_idx')||'
75+
query = 'create index '||_pgr_quote_ident(tname||'_'||colname||'_idx')||'
7676
on '||tabname||' using btree('||quote_ident(colname)||')';
7777
end if;
7878
perform _pgr_msg(msgKind, fnName, 'Adding index ' || tabname || '_' || colname || '_idx');

‎sql/common/findClosestEdge.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -69,7 +69,7 @@ BEGIN
6969
USING HINT = 'Please veryfy the column names: id, the_geom';
7070
END;
7171

72-
sql ='
72+
sql ='
7373
WITH
7474
safesql AS (' || safe_sql || '),
7575
close_ones AS
@@ -83,7 +83,7 @@ BEGIN
8383
third_q AS
8484
(SELECT DISTINCT(id) id, distance, line, blade FROM close_ones WHERE distance = (select min_dist from closest_ones) ORDER BY id LIMIT 1),
8585
dump_values AS
86-
(SELECT id,
86+
(SELECT id,
8787
(ST_length(ST_GeometryN(st_split(line, blade),1))/ST_length(line))::FLOAT AS fraction,
8888
(line << ' || quote_literal(point_geom::TEXT) || '::geometry) as rightSide
8989
FROM third_q)

‎sql/common/pgRouting-header.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
---
88
--- pgRouting provides geospatial routing functionality.
99
--- http://pgrouting.org
10-
--- copyright
10+
--- copyright
1111
--- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1212
---
1313
---

‎sql/common/pgr_parameter_check.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -37,14 +37,14 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
3737

3838
CREATE OR REPLACE FUNCTION _pgr_parameter_check(fn text, sql text, big boolean default false)
3939
RETURNS bool AS
40-
$BODY$
40+
$BODY$
4141

4242
DECLARE
4343
rec record;
4444
rec1 record;
4545
has_rcost boolean;
4646
safesql text;
47-
BEGIN
47+
BEGIN
4848
IF (big) THEN
4949
RAISE EXCEPTION 'This function is for old style functions';
5050
END IF;
@@ -80,7 +80,7 @@ CREATE OR REPLACE FUNCTION _pgr_parameter_check(fn text, sql text, big boolean d
8080
USING ERRCODE = 'XX000';
8181
END IF;
8282
END IF;
83-
83+
8484

8585
IF fn IN ('astar') THEN
8686
BEGIN
@@ -135,7 +135,7 @@ CREATE OR REPLACE FUNCTION _pgr_parameter_check(fn text, sql text, big boolean d
135135
EXCEPTION
136136
WHEN OTHERS THEN
137137
has_rcost = false;
138-
return has_rcost;
138+
return has_rcost;
139139
END;
140140
if (has_rcost) then
141141
IF (big) then

0 commit comments

Comments
 (0)