Re: understand basics - multiple cars in a database - selection of one - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: understand basics - multiple cars in a database - selection of one
Date
Msg-id CAKoxK+4ZvUdm55srpYOn8i=qV7nMMNo=NWpa=S7ZtU7b68a1ew@mail.gmail.com
Whole thread Raw
In response to Re: understand basics - multiple cars in a database - selection of one  (avpro avpro <avprowebeden@gmail.com>)
Responses Re: understand basics - multiple cars in a database - selection of one  (avpro avpro <avprowebeden@gmail.com>)
List pgsql-novice
On Tue, Feb 4, 2014 at 10:34 PM, avpro avpro <avprowebeden@gmail.com> wrote:
> let me write it differently:
> "when the application is lunched, I would like to select one car and then
> every property, option, transaction (applicable to this car) should be
> recorded by the application automatically. "
>
> the property, option, transaction should be recorded by the application
>
> hope this helps. thanks

Oh yes, line feeds definitely made it a lot more understandable!
I suppose what you need here is a good mapper for your application
(e.g., hibernate, but hey, you did not mention your application
language).
I suspect you are asking for a lazy master-child table lookup but hey,
you did not mention your tables.
This could help: http://qt-project.org/doc/qt-4.8/sql-masterdetail.html
but I recommend you getting either a better knowledge of your aim or a
good SQL/relational theory book.

Luca


pgsql-novice by date:

Previous
From: Payal Singh
Date:
Subject: Re: understand basics - multiple cars in a database - selection of one
Next
From: Michael Wood
Date:
Subject: Re: Update with last known location?