Re: Postgresql equal join on function with columns not use index

2023-06-15 Thread Pavel Stehule
Hi čt 15. 6. 2023 v 10:32 odesílatel James Pang (chaolpan) napsal: >Thanks a lot, we use orafce 3.17, and there some varchar2 columns and > function indexes depends on oracle.substr too. Is it ok to upgrade to > orafce version 4.4 by “alter extension update to ‘4.4’? it’s online to do >

RE: Postgresql equal join on function with columns not use index

2023-06-15 Thread James Pang (chaolpan)
Thanks a lot, we use orafce 3.17, and there some varchar2 columns and function indexes depends on oracle.substr too. Is it ok to upgrade to orafce version 4.4 by “alter extension update to ‘4.4’? it’s online to do that ? Thanks, James From: Pavel Stehule Sent: Tuesday, June 13, 2023 11