By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Attribute 'rtrim' is repeated

P: n/a

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 28 Oct 2003 Ly********@asu.edu wrote:

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?


You probably want to give your columns names,
SELECT TRIM(...) AS strk_sym_cmplt, TRIM(...) AS stk_sym, ...

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.