update questsion

From: "Donald Braman" <donald(dot)braman(at)yale(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: update questsion
Date: 2001-02-28 18:47:25
Message-ID: NEBBIEDPCOLBEHHPHCIMEEGMECAA.donald.braman@yale.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm trying to update a column to it's orignal contents plus a space plus the
contents of another column.

UPDATE cases
SET citation = citation + ' ' + text(year);

(citation is text type and year is char type, hence the use of text()
function)
I get: Unable to identify an operator '+' for types 'text' and 'unknown'
I can't find any documentation on how to this sort of thing, so any help is
appreciated. -Don

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ERIC Lawson - x52010 2001-02-28 19:22:19 Re: update questsion
Previous Message Allen.Kimberly 2001-02-28 15:45:18 postgres 6.5.2 questions