Porting postgresql sql functions with select in them

rribas

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?