Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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()
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group