[postgis-users] How to insert the geometry field of a record with trigger and function

[Veronique Chaffard]

I would like to insert the geometry field of a record by using a trigger 
and a fonction, after the insertion of the other fields;The X and Y 
coordinates are saved into 2 fields: LAT and LONG. The geometry field 
type is a point. 

My table is declared as:
CREATE TABLE TEST (
    ID serial not null,
    NOM VARCHAR(50) not null,
    LONG FLOAT8 not null,
    LAT  FLOAT8 not null,
constraint PK_TEST primary key (ID)
);
SELECT AddGeometryColumn('','test','geom','-1','POINT',2);

Could you help me ?

Thanks in advance.