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: 41AAA865.2000102@shemesh.biz (view raw or flat)
Thread:
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 
supported?

>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

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/


In response to

Responses

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-2014 The PostgreSQL Global Development Group