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

Re: insert a -1 into a bigint ?

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
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 18:16:36
Message-ID: 2FAACE70-C77D-4789-A02E-7CA34CF0DF16@kevinkempterllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Shane AmblerDate: 2008-05-20 19:22:30
Subject: Re: insert a -1 into a bigint ?
Previous:From: kevin kempterDate: 2008-05-20 18:14:26
Subject: insert a -1 into a bigint ?

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