From: | John Tregea <john(at)debraneys(dot)com> |
---|---|
To: | Aaron Bono <postgresql(at)aranya(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Joining a result set from four (4) tables |
Date: | 2006-08-03 00:51:02 |
Message-ID: | 44D14876.8090107@debraneys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo De León | 2006-08-03 01:33:34 | Re: Problem while using lo_import and lo_export |
Previous Message | Aaron Bono | 2006-08-03 00:13:51 | Re: i need informarion regarding functions and arrays... |