Re: insert a -1 into a bigint ?

kevin kempter wrote:
> Hi All:
>

> I want to insert some data along with a -1 for two of the bigint
> columns. like this:
>
> insert into seg_id_tmp7
> ( customer_srcid,
> show_srcid,
> show_name,
> season_srcid,
> season_name,
> episode_srcid,
> episode_name,
> segment_type_id,
> segment_type,
> segment_srcid,
> segment_name,
> create_dt )
> select
> t8.customer_srcid,
> t8.show_srcid,
> t8.show_name,
> t8.season_srcid,
> t8.season_name,
> t8.episode_srcid,
> t8.episode_name
> -1::bigint ,
> 'none',
> -1::bigint ,
> 'none',
> (select start_dt from load_start_date)
> from
> seg_id_tmp8 t8
> ;
>
>
>
> I've also tried without the ::bigint cast on the above query.
>
>
> I always get this error:
>
> sql:load_sl_cd_segment_dim.sql:237: ERROR: operator does not exist:
> character varying - bigint

Try a comma before the -1

You are trying to enter - "t8.episode_name -1::bigint" into the column

hence - "character varying - bigint" does not work

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz