Default in code number type

Accepted Solution

Default in code number type

Hello,

 

I have lots of code like this:

nvl (number_value, 1)

Problem is that I would need to typecast all that code. Is there any way arround that? Mabye some setting? I am still doing this in EDB POstgres migration portal.

 

thank you for any help or replay, Marko

Accepted Solutions (1)

Accepted Solutions (1)

EDB Team Member
Solution

Currently, EDB Migration Portal does not have any setting by which user can apply the same change in all code.

 

Informative Note: Current implementation of nvl() function in EDB Postgres supports following datatypes: Character Varying, Numeric, Date, Timestamp with time zone and Timestamp without time zone.

 

Hope this helps.

Answers (0)

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks