Artem Pavlyutkin
Artem Pavlyutkin
@clauderic ping
My solution (based [https://pietrzakadrian.com/blog/virtual-column-solutions-for-typeorm](https://pietrzakadrian.com/blog/virtual-column-solutions-for-typeorm)) is as follows: ``` @VirtualColumn() distance?: number | null; ``` ``` const queryBuilder = this.profilesRepository .createQueryBuilder('profile') .leftJoin('profile.user', 'user') .addSelect( `ST_Distance(ST_SetSRID(ST_MakePoint(${user.latitude}, ${user.longitude}), 4326), user.location, true)`, 'distance' )...
I need select user distance `ST_Distance(ST_SetSRID(ST_MakePoint(${user.latitude}, ${user.longitude}), 4326), user.location, true)` but i get an error: syntax error query console: `(SELECT "profile"."id" AS "profile_id", profile.76713, 37.729395, 4326),`