Hi there. Sorry if this is a silly question, I'm relatively new to PostgreSQL. I'm trying to copy information from one column, modify it and place it in another column. Is there some shortcut way to do this with an UPDATE statement? So far I'm thinking I'll need to copy the table schema and then INSERT...SELECT using the desired expressions. Does that seem reasonable? ---- Nels Lindquist <*> Information Systems Manager Morningstar Air Express Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq