Porting postgresql sql functions with select in them
I'm porting some tables and queries from postgresql, however they make use of functions that contain select statements. I found out that vertica doesn't allow that. What options do I have in this case? As far as I can tell I could do one of the following:
- Create an external procedure, that would run the select. I feel like that would have a bad performance.
- Get rid of the function and inline it in the query. The disadvantage is that I have to significantly modify the existing queries and also repeat the same logic on all queries using it.
- Anything else I can do?