0

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

How to create a temporary table using VALUES in PostgreSQL

fcsr
  • 101
  • 2

0 Answers0