How to use left function in subquery using Postgres

Question

I have a query like this :

select * from employee where (employee_id in (SELECT DISTINCT 
SubTable.blockid 
        FROM 
                  broad.territory_block 
                  BlockSubTable 
                                         WHERE  ( ( 
                  BlockSubTable.id IN ( 398 ) ))))

Now here my employee_id is of 10 digits and the output of the subquery would be of 13 digits. I tried using left('',10) for matching the subquery output but getting error for misplaced left function. Can someone please help me how should I use left function to match the result. I need to match the employee_id with the subquery output

P.S : This is not the actual query, created for explaining the problem

Sample data and desired results would really help. I'm totally lost why you wold compare something called employeeid to something called blockid. — Gordon Linoff
– Gordon Linoff, Commented Aug 13, 2020 at 14:39
did u tried SELECT DISTINCT LEFT(SubTable.blockid , 10) FROM ... — I S
– I S, Commented Aug 13, 2020 at 14:42

user330315 · Accepted Answer · 2020-08-13 14:41:55Z

3

Just apply it to the column:

select * 
from employee 
where employee_id in (SELECT left(blockid, 13)
                      FROM  BlockSubTable 
                      WHERE  BlockSubTable.id IN ( 398 ) )

answered Aug 13, 2020 at 14:41

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

CoderBeginner Over a year ago

Thank you so much for your quick help.!! :D

Akhilesh Mishra Over a year ago

@Developer52 you should accept the answer if it resolves your problem

Collectives™ on Stack Overflow

How to use left function in subquery using Postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related