Forum OpenACS Q&A: Re: Why unique screen_name in users table

Collapse
Posted by Nima Mazloumi on
Something like this:

update users set screen_name = (select first_names from persons p where p.person_id = user_id) || user_id;