Is there a way to create temporary tables using CTE's and WITH/VALUES in Vertica?
0
votes
0
answers
633
views
I'm trying to create a temporary table using CTE's/With.
Is there a Vertica equivalent for this approach?
WITH vals (k,v) AS (VALUES (0,-9999), (1, 100))
SELECT * FROM vals;
I want to be able to use the data without creating a temp table
https://dba.stackexchange.com/questions/86724/how-to-create-a-temporary-table-using-values-in-postgresql
Asked by fcsr
(101 rep)
Feb 27, 2020, 07:11 PM