From: | BERTRAND Joël <joel(dot)bertrand(at)systella(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | "=" or ":=" ? |
Date: | 2008-02-28 16:21:32 |
Message-ID: | 47C6DF8C.4080005@systella.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I'm trying to optimize assign_vertex_id() function provided by
pgRouting/PostGIS. In this function, I can see :
DECLARE
points record;
i record;
source_id int;
target_id int;
pre varchar;
post varchar;
srid integer;
BEGIN
BEGIN
DROP TABLE vertices_tmp;
EXCEPTION
WHEN UNDEFINED_TABLE THEN
END;
EXECUTE 'CREATE TABLE vertices_tmp (id serial)';
FOR i IN EXECUTE 'SELECT srid FROM geometry_columns WHERE
f_table_name='''|| quote_ident(geom_table)||'''' LOOP
END LOOP;
srid := i.srid;
EXECUTE 'SELECT addGeometryColumn(''vertices_tmp'', ''the_geom'',
'||srid||', ''POINT'', 2)';
CREATE INDEX vertices_tmp_idx ON vertices_tmp USING
GIST (the_geom);
pre = '';
post = '';
I don't understand last assignations. In pgsql documentation, ther is
written that all assignations have to be written with ":=", not with
"=". What is the difference between "=" and ":=" ? I don't find any
information about "=".
Regards,
JKB
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-02-28 16:42:31 | Re: initlocation on windows |
Previous Message | Colin Wetherbee | 2008-02-28 16:18:57 | Re: HELP FOR LOADING a .psql file (same question again but explained neatly) |