Yes. It will make the pedals feel like they are further forward, and it will put more weight over the rear tire/take weight off the front tire.

Hence everyone saying to get a longer stem first, as the setback seatpost will effectively change the geometry.