Re: a wierd query

From: sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: a wierd query
Date: 2004-05-13 07:34:35
Message-ID: 200405131134.35156.sad@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> i require the dictinct values from (visualizing each column
> result as a set) the union of the two columns

select distinct a as F from table
union
select distinct b as F from table;

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ashok@kalculate.com 2004-05-13 08:07:08 a wierd query
Previous Message Achilleus Mantzios 2004-05-13 07:34:26 Re: a wierd query