Tim

Messing around to help Leslie I found

ElevateDB Error #700 An error was found in the statement at line 1 and column 28 (Invalid expression null found, a constant NULL value is not allowed as a SELECT expression)

Why?

I can see a valid use for having constant NULLs in a SELECT especially in CREATE TABLE AS

Roy Lambert

<< ElevateDB Error #700 An error was found in the statement at line 1 and
column 28 (Invalid expression null found, a constant NULL value is not
allowed as a SELECT expression)

Why? >>

Because there's no data type associated with the NULL value (can be any
type).
You need to cast it to the data type you want the SELECT column shall have,
e.g.:

select cast(null as char varying(50)) ...

Ole Willy Tuv

Ole


Thanks - that makes sense, even to a null hater.

Roy Lambert