Re: Constructing column from different individual fields in same row.

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alex Martinoff <froggle2003(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Constructing column from different individual fields in same row.
Date: 2003-09-10 13:08:08
Message-ID: 20030910130808.GC25627@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 09, 2003 at 21:02:21 -0700,
Alex Martinoff <froggle2003(at)yahoo(dot)com> wrote:
> I'm wondering if it's possible to have a query construct a column
> where the value of the column at each row is taken from another field
> in that same row. For example, suppose you have a table like:

You can use CASE to do this.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank van Vugt 2003-09-10 13:24:59 plpgsql doesn't coerce boolean expressions to boolean
Previous Message Bruno Wolff III 2003-09-10 12:30:04 Re: The ..... worm