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

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Constructing column from different individual fields in same row.
Дата
Msg-id 20030910130808.GC25627@wolff.to
обсуждение исходный текст
Ответ на Constructing column from different individual fields in same row.  (froggle2003@yahoo.com (Alex Martinoff))
Ответы Re: Constructing column from different individual fields in  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Bruno BAGUETTE"
Дата:
Сообщение: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Следующее
От: Frank van Vugt
Дата:
Сообщение: plpgsql doesn't coerce boolean expressions to boolean