Hfrhyu

I have a layer of points and want to join some data from polygons where the two coincide. I might have several points in one poly.

The points were generated from a CSV as;

UPDATE t_osab_with_voa_ndr SET geom_point_4258 = ST_SetSrid(ST_MakePoint(longitude, latitude),4258);

Where they are stated as being ETRS89 projection which is SRID 4258

I'm running into problems as the points have SRID 4258 and the Polys are 27700 I've tried using ;

ALTER TABLE t_osab_with_voa_ndr
ALTER COLUMN geom_point_4258 TYPE geometry(point,27700)
USING ST_Transform(geom_point_4258,27700);

When I look in QGIS I see this;

But when I run;

create or replace view v_spatialjoin_northeast_st_within1 as
select * from t_osab_with_voa_ndr , d_geom_northeast where st_within(t_osab_with_voa_ndr.geom_point, d_geom_northeast.geom);

I get no results when I can see I should

Question 1.
Can i combine the ST_Within / ST_Interects and specify the SRID in the process or am i better transforming the points first?

EDIT:
Reason for my blanks was SQL problem with ST_Within, but still interested to know if you can set SRID or what is the fastest way to execute this

The reason for the blanks in this instance was due to my query, what worked was rewriting this as below, code taken from good blog post here

SELECT pts.*, blocks.inspireid as inspire_poly_id
FROM t_osab_with_voa_ndr AS pts
INNER JOIN d_geom_northeast AS blocks
ON st_within(pts.geom_point, blocks.geom);

For me what works is to use the ST_transforn instead of ST_Set SRID in order to change the SPATIAL REFERENCE SYSTEM. After that the SPATIAL query wtih INNER JOIN or the other one works perfectly.
Here is the
explanation.