Re: insert a -1 into a bigint ?

I forgot to mention - I'm running version 8.3.1

On May 20, 2008, at 12:14 PM, kevin kempter wrote:

> 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
>
>
>
> --
> 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