Re: insert a -1 into a bigint ?

[Shane Ambler <pgsql@xxxxxxxxxx>]

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