From: | kevin kempter <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | insert a -1 into a bigint ? |
Date: | 2008-05-20 18:14:26 |
Message-ID: | B93EDA1C-3B80-4949-B0C2-36F9EBCF6411@kevinkempterllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | kevin kempter | 2008-05-20 18:16:36 | Re: insert a -1 into a bigint ? |
Previous Message | Scott Marlowe | 2008-05-20 17:38:38 | Re: how i can restrict databaseusers ? |