framework/resources/Functional/limit0/create_views_postgres.sql

create or replace view optional_type_v as 
select
	cast(c_varchar as varchar(100)) 	as c_varchar,
	cast(c_integer as integer)		as c_integer,
	cast(c_bigint as bigint)		as c_bigint,
	cast(c_float as float)			as c_float,
	cast(c_double as double precision)	as c_double, 
	cast(c_date as date)			as c_date,
	cast(c_time as time)			as c_time,
	cast(c_timestamp as timestamp)		as c_timestamp,
	cast(c_boolean as boolean)		as c_boolean
from 
	j1
;

create or replace view required_type_v as      
select
        cast(c_varchar as varchar(100))		as c_varchar,
        cast(c_integer as integer)		as c_integer,
        cast(c_bigint as bigint)		as c_bigint,
        cast(c_float as float)			as c_float,
        cast(c_double as double precision)	as c_double,
        cast(c_date as date)			as c_date,
        cast(c_time as time)			as c_time,
        cast(c_timestamp as timestamp)		as c_timestamp,
        cast(c_boolean as boolean)		as c_boolean
from 
        j3
;