On 18/05/2012 21:30, J.V. wrote: > update table set varcharid = ''' || tmp_var || '''
Others have answered your question, but there's a problem here too; you don't need the quotes. This statement should be just: update table set varcharid = tmp_var; ...assuming that the types match, of course. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
