Re: [GENERAL] [SQL] Flight numbers data

2006-03-29 Thread Achilleus Mantzios
O Josh Rovero έγραψε στις Mar 29, 2006 : > We built an operational flight tracking and weather system that uses > Postgresql, > http://www.sonalysts.com/wXstation > > One data feed (FAA ASDI) uses both aircraft registration > numbers (tail numbers) and airline-assigned flight numbers. Typicall

Re: [GENERAL] [SQL] Flight numbers data

2006-03-29 Thread Achilleus Mantzios
O Scott Marlowe έγραψε στις Mar 29, 2006 : > On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote: > > Hi, i am in the process of writing an application about > > tickets, flights, etc, and i am thinking of getting the primitive > > data ready at the begining and doing it the right way, > > (e.g.

Re: [GENERAL] [SQL] Flight numbers data

2006-03-29 Thread Josh Rovero
We built an operational flight tracking and weather system that uses Postgresql, http://www.sonalysts.com/wXstation One data feed (FAA ASDI) uses both aircraft registration numbers (tail numbers) and airline-assigned flight numbers. Typically if you have the latter, you won't get the former.

Re: [GENERAL] [SQL] Flight numbers data

2006-03-29 Thread Simon Riggs
On Wed, 2006-03-29 at 10:50 -0600, Scott Marlowe wrote: > > Has anyone from the postgresql camp ever solved such a problem? > > Where I work, we're building a middle level system (look up the website > that goes with my domain). And if we weren't in the airline reservation > industry, we couldn'

Re: [GENERAL] [SQL] Flight numbers data

2006-03-29 Thread Scott Marlowe
On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote: > Hi, i am in the process of writing an application about > tickets, flights, etc, and i am thinking of getting the primitive > data ready at the begining and doing it the right way, > (e.g. the user will just select a flight number and doesnt