Attribute 'rtrim' is repeated
| От | Lynn.Tilby@asu.edu |
|---|---|
| Тема | Attribute 'rtrim' is repeated |
| Дата | |
| Msg-id | 1067373740.3f9ed4acb4e2a@webmail.asu.edu обсуждение исходный текст |
| Ответы |
Re: Attribute 'rtrim' is repeated
|
| Список | 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
В списке pgsql-general по дате отправления: