Re: [GENERAL] Constructing column from different individual fields in

2003-09-10 Thread Bruce Momjian
Bruno Wolff III wrote: > On Tue, Sep 09, 2003 at 21:02:21 -0700, > Alex Martinoff <[EMAIL PROTECTED]> 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 y

Re: [GENERAL] Constructing column from different individual fields

2003-09-10 Thread Mike Mascari
Alex Martinoff 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: > > create table users ( > uid serial, > nickname varchar(2