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

Re: sequencing two tables

From: Shachar Shemesh <psql(at)shemesh(dot)biz>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sequencing two tables
Date: 2004-11-29 04:41:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Stephan Szabo wrote:

>We don't support join conditions like the above at this point.  The
>message isn't terribly helpful though.
Purely out of interest, what does that message mean? Why aren't they 

>Fortunately, I think some variant like
> select table1.field from table1
>  union all
> select table2.field from table2;
>will give you the output you're looking for.
It's exactly what I'm looking for. Thank you and Tom.


Shachar Shemesh
Lingnu Open Source Consulting ltd.

In response to


pgsql-general by date

Next:From: Greg StarkDate: 2004-11-29 06:18:05
Subject: Re: Boolean error
Previous:From: Doug McNaughtDate: 2004-11-29 03:56:59
Subject: Re: [HACKERS] Adding Reply-To: <listname> to Lists

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