Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 14:28:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Teradata does not have syntax for literal tuples. You'll need to do something such as insert the values into a table (could be a VOLATILE table) and use a subquery.

For a very small number of values, you could consider UNION ALL with a SELECT (without a FROM clause) for each tuple.

	<Prev	Next>		<<First	<Prev	Next>	Last>>