Skip site navigation (1) Skip section navigation (2)

Re: sequencing two tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shachar Shemesh <psqll(at)shemesh(dot)biz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sequencing two tables
Date: 2004-11-29 02:44:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Shachar Shemesh <psqll(at)shemesh(dot)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

In response to

pgsql-general by date

Next:From: Adam ErnstDate: 2004-11-29 02:48:21
Subject: Table and Field Schemas
Previous:From: Uwe C. SchroederDate: 2004-11-29 02:41:50
Subject: How many views...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group