From: John Tregea <john@debraneys.com>
To: Aaron Bono <postgresql@aranya.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Joining a result set from four (4) tables
Date: Thu, 03 Aug 2006 08:51:02 +0800
Message-ID: <44D14876.8090107@debraneys.com> (raw)
In-Reply-To: <bf05e51c0608021101x617bf7eap519d2140e8b8c393@mail.gmail.com>
References: <44CDB1EF.6000508@debraneys.com>
<bf05e51c0607310112wbc75fedkb21773c5bb64d11e@mail.gmail.com>
<44CE9C63.7010409@debraneys.com>
<bf05e51c0608011232jc6cae94wa82f3e6148766484@mail.gmail.com>
<44D02242.5050309@debraneys.com>
<bf05e51c0608021101x617bf7eap519d2140e8b8c393@mail.gmail.com>
Hi Aaron,
The query builder to generate joins that you mentioned is exactly what I
am going to do doing this time. That is one of the reasons I have the
generic field names for the primary and foreign key fields. Then I only
have to pass the search criteria the table names and which direction I
want to do the joins.
Thanks again for your help.
Regards
John T
Aaron Bono wrote:
> We all find ourselves in different situations and because of that,
> what works for one person, doesn't work for another - so I
> understand. Good luck with the application and future queries. Maybe
> you can use the existing structure of your application to help create
> a query builder so you can have it write a lot of your joins for you.
> That should help avoid a lot of simply typos or mix-ups when hand
> writing your queries.
>
> I am glad the queries worked for you.
>
> -Aaron
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: john@debraneys.com, postgresql@aranya.com
Subject: Re: Joining a result set from four (4) tables
In-Reply-To: <44D14876.8090107@debraneys.com>
* 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