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@sss.pgh.pa.us> wrote:
> Lauri Kajan <lauri.kajan@gmail.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
>