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

Re: Combining queries

From: Mark Kelly <pgsql(at)wastedtimes(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Combining queries
Date: 2011-02-21 00:31:52
Message-ID: 201102210031.52537.pgsql@wastedtimes.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Lew.

On Sunday 20 Feb 2011 at 19:13 Lew wrote:
> One trusts that the result columns in the two tables have compatible types.

Yes, the column definitions all match.
 
> I am curious how you interpret the "id" result in that query.

The IDs have distinct formats that differ between tables, created by the 
legacy system that originated the records (P-nnnn and C-nnnn). Each row also 
has an integer primary key that my code uses internally, but I don't need it 
in these results.

Thanks for the help, I'm looking forward to playing with UNION ALL when I go 
back to work tomorrow, and your tip about eliminating the test is interesting.

Cheers,

Mark

In response to

Responses

pgsql-novice by date

Next:From: LewDate: 2011-02-21 00:40:31
Subject: Re: Combining queries
Previous:From: LewDate: 2011-02-20 19:13:32
Subject: Re: Combining queries

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