Postgres Pro
Downloads
Home   >   mailing lists

Re: Constructing column from different individual fields in same row. - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Constructing column from different individual fields in same row.
Date
Msg-id 20030910130808.GC25627@wolff.to
Whole thread Raw
In response to Constructing column from different individual fields in same row.  (froggle2003@yahoo.com (Alex Martinoff))
Responses Re: Constructing column from different individual fields in  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
On Tue, Sep 09, 2003 at 21:02:21 -0700,
  Alex Martinoff <froggle2003@yahoo.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.

pgsql-general by date:

Previous
From: "Bruno BAGUETTE"
Date:
Subject: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Next
From: Frank van Vugt
Date:
Subject: plpgsql doesn't coerce boolean expressions to boolean