From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Need help with a special JOIN
Date: Sat, 29 Sep 2012 18:02:23 +0200
Message-ID: <50671B8F.4090504@gmx.net> (raw)
Hi,
asume I've got 2 tables
objects ( id int, name text )
attributes ( object_id int, value int )
attributes has a default entry with object_id = 0 and some other where
another value should be used.
e.g.
objects
( 1, 'A' ),
( 2, 'B' ),
( 3, 'C' )
attributes
( 0, 42 ),
( 2, 99 )
The result of the join should look like this:
object_id, name, value
1, 'A', 42
2, 'B', 99
3, 'C', 42
I could figure something out with 2 JOINs, UNION and some DISTINCT ON
but this would make my real query rather chunky. :(
Is there an elegant way to get this?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: Need help with a special JOIN
In-Reply-To: <50671B8F.4090504@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox