I've got a trigger in my db that I'm having trouble with..
Code:
insert into fishdata(fish_point) values(GeomFromText('POINT(NEW.latitude NEW.longitude)', -1));
The problem is obviously that latitude and longitude are being passed as strings instead of being evaluated first. I've tried using || to concat (such as 'POINT(' || NEW.latitude etc etc) but that doesn't work.
Any suggestions would be appreciated.