insert a -1 into a bigint ?

[kevin kempter <kevin@xxxxxxxxxxxxxxxxxxx>]

Hi All:


I have this table:

# \d seg_id_tmp7
                Table "public.seg_id_tmp7"
     Column      |            Type             | Modifiers
-----------------+-----------------------------+-----------
 customer_srcid  | bigint                      |
 show_srcid      | bigint                      |
 show_name       | character varying           |
 season_srcid    | bigint                      |
 season_name     | character varying           |
 episode_srcid   | bigint                      |
 episode_name    | character varying           |
 segment_type_id | bigint                      |
 segment_type    | character varying           |
 segment_srcid   | bigint                      |
 segment_name    | character varying           |
 create_dt       | timestamp without time zone |



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
LINE 22:  -1::bigint ,
          ^
HINT:  No operator matches the given name and argument type(s). You  
might need to add explicit type casts.





Thanks in advance for any help, advice, etc..


/Kevin