Skip site navigation (1) Skip section navigation (2)

Re: insert a -1 into a bigint ?

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: insert a -1 into a bigint ?
Date: 2008-05-20 19:22:30
Message-ID: 483324F6.7030705@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: kevin kempterDate: 2008-05-20 19:42:52
Subject: Re: insert a -1 into a bigint ?
Previous:From: kevin kempterDate: 2008-05-20 18:16:36
Subject: Re: insert a -1 into a bigint ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group