Re: insert a -1 into a bigint ?

wow, good catch.

Thanks for taking the time to look.

On May 20, 2008, at 1:22 PM, Shane Ambler wrote:

> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin