Re: sequencing two tables - Mailing list pgsql-general

From Tom Lane
Subject Re: sequencing two tables
Date
Msg-id 1794.1101696251@sss.pgh.pa.us
Whole thread Raw
In response to sequencing two tables  (Shachar Shemesh <psqll@shemesh.biz>)
List pgsql-general
Shachar Shemesh <psqll@shemesh.biz> writes:
> I thought about doing something like this:
> select |COALESCE(table1.field, table2.field) as field from table1 full
> outer join table2 on false

Perhaps you are looking for UNION ALL?  If not, I'm not sure what you
expect this query to mean.

            regards, tom lane

pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: How many views...
Next
From: Adam Ernst
Date:
Subject: Table and Field Schemas