Re: null values in a view

This worked.
Thank you all!

I know the casting is quite basic operation but could this be added to
the CREATE VIEW documentation? Now there is only an example:
CREATE VIEW vista AS SELECT text 'Hello World' AS hello;
The same syntax won't work with other type as Tom wrote.

-Lauri

On Wed, Oct 5, 2011 at 5:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Lauri Kajan <lauri(dot)kajan(at)gmail(dot)com> writes:
>> This works with other values but not with nulls:
>
>> CREATE VIEW view1 AS
>> SELECT
>>   attribute1 as a1,
>>   text null as a2,
>>   text 'test' as a3
>> FROM
>>   table;
>
> FYI, the syntax  typename 'literal'  works *only* with string literals,
> not anything else.  For any other target you have to write
> CAST(value AS typename)  or equivalently  value::typename.
> CAST is SQL-standard, :: is a Postgres-ism.
>
>                        regards, tom lane
>