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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin