Thank you Nicolas, this seems to be exactly what I was looking for, but I am
having some problems with parts of it.
1) the inner SELECT works perfectly, no problem at all getting the UNION to work
2) the outer SELECT gave me 3 problems (I first created an empty table called
track_point with id
Hi,
Yes you can, you use the case statement.
Here is an example:
create table ttt (id serial primary key,
geocode varchar(12),
lat int,
lon int);
insert into ttt values (default, '1234/5678', null, null);
insert into ttt values (default, '12
Hi Bret,
Thanks for your help. I am now
able to update lat and long column as explained by you.
Sometimes I attributes like ‘0002N/5155’
in geocode column. Now in the lat_dms column the attribute should be ‘000200’
and ‘-515500’in long_dms column. But how do I get the ‘N’ in ‘lat’ part
recogn