DAVID ROTH writes:
> The code I am migrating uses the EXECUTE immediate form for almost
> everything. The path of least resistance for me is to just copy the code to
> Postgres and change "EXECUTE IMMEDIATE" to "EXECUTE".
> I am asking about performance differences to see if it is worth convert
Agreed.
The code I am migrating uses the EXECUTE immediate form for almost everything.
The path of least resistance for me is to just copy the code to Postgres and
change "EXECUTE IMMEDIATE" to "EXECUTE".
I am asking about performance differences to see if it is worth converting code
that does
DAVID ROTH schrieb am 18.11.2021 um 15:15:
> I am working on a large Oracle to Postgres migration.
> The existing code frequently constructs a string and then uses Oracle's
> "EXECUTE IMMEDIATE" to run it.
> "EXECUTE" has the same functionality in Postgres.
>
> For example:
> CREATE or REPLACE FUN