From: | Lynn(dot)Tilby(at)asu(dot)edu |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Attribute 'rtrim' is repeated |
Date: | 2003-10-28 20:42:20 |
Message-ID: | 1067373740.3f9ed4acb4e2a@webmail.asu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In trying to trim some data while selecting and loading from 2 tables
into 1 I get the following:
SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM
s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_sym,
o.strk_yr, s.strk_num, s.exp_sym, s.exp_mo, s.exp_mo_num, s.exp_yr,
s.exp_yr_num, s.exp_date, s.exp_date_dys, o.opn, o.hi, o.lw, o.cls, o.vol,
o.opn_intrst, o.bd, o.ak
INTO TABLE optn_calls_tbl
FROM option_data_oprtnl o, strk_data_oprtnl s
WHERE TRIM(TRAILING ' ' FROM o.strk_sym_ful) = TRIM(TRAILING ' ' FROM
s.strk_sym_cmplt) AND s.c_p = 'C';
ERROR: Attribute 'rtrim' is repeated
I understand that rtrim is an underlying function to trim. Is this a BUG???
How do I fix this problem?
Thanks for your help!
Lynn Tilby
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Gigger | 2003-10-28 21:51:10 | Re: SCSI vs. IDE performance test |
Previous Message | Tom Lane | 2003-10-28 20:13:51 | Re: shared memory on OS X - 7.4beta4 |