This is basically the same thing I said here, just modified to produce the end point instead of a line:
ST_SetSRID(ST_Translate(ST_Rotate(ST_MakePoint(-1 * dist_field,0.0),
ST_Y(the_geom)),ST_SRID(the_geom)) AS end_point_geom
start_points is the table containing your starting points,
the_geom in that table is the geometry column,
dist_field is the distance field and
bearing_field is the bearing field.
You may need to change the direction of the initial line (
ST_MakePoint(-1 * dist_field,0.0)) to vertical (swap the coordinates/field name) depending on how you are measuring your bearing.