Re: Auxiliary insert parameter

2008-02-15 Thread oliverw
If I could use a constant, I wouldn't have made it a variable in the first place :) Chetan Nayak wrote: > > why don't you just hard code it to some value . > Something like to_tsvector(' ',#item_name#). > Hope this helps > > Thanks > Chetan > &

Re: Auxiliary insert parameter

2008-02-15 Thread oliverw
; no greater peril than when we cannot see the chains on our minds > because there are yet no chains on our feet. > -- Michael Reid > > > > > > oliverw

Auxiliary insert parameter

2008-02-15 Thread oliverw
INSERT INTO item_names (item_id, item_name, item_name_tsv, culture_id) VALUES(#item_id#, #item_name#, to_tsvector(#ts_config#, #item_name#), #culture_id# ) In the above insert statement the #ts_config# is only needed as an argument to the to_tsvector() function call. Thus I would like to avoi