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.


Raymond O'Donnell :: Galway :: Ireland

Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:

[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