The stored procedure won’t just return the result of the last SELECT. You need to actually return the value: You’re getting the error because Postgres expects the function to return something of type text, but your function doesn’t return anything.
You can have multiple CTEs in one query, as well as reuse a CTE: Note, however, that SQL Server may reevaluate the CTE each time it is accessed, so if you are using values like RAND(), NEWID() etc., they may change between the CTE calls.
I’m trying to use MySQL to create a view with the “WITH” clause But it doesn’t seem like MySQL supports this. I thought this was pretty standard and I’m sure Oracle supports this. Is there anyway to force MySQL to use the “WITH” clause? I’ve tried it with the MyISAM and innoDB engine. Both of … Read more
Sample DDL Make sure that the table is deleted after use