Search Postgresql Archives

Re: varchar for loops possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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
rod@xxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux