No you'd have to do it with a subquery. cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_first_raise and chps.amt_p_effective_stack / cl.amt_bb between X and Y) will filter to hands where...
Was there a reason for the move other than to save hard drive space? PokerStars installation is actually fairly small but if there were other concerns that might help me advise you better.
Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in...
Changing PostgreSQL versions requires work - I'd recommend uninstalling 9.5 and reinstalling 9.3. That should work better for you and has the potential to keep your databases around - switching to 9.5 your 9.3 data folder will not be usable.