X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 659B011F6023; Wed, 29 Mar 2006 04:17:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63873-05; Wed, 29 Mar 2006 04:17:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id D0A5211F66B9; Wed, 29 Mar 2006 04:17:10 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k2T9NlOp004954; Wed, 29 Mar 2006 12:23:47 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k2T8HXA7004827; Wed, 29 Mar 2006 11:17:53 +0300 Date: Wed, 29 Mar 2006 11:17:33 +0300 (EEST) From: Achilleus Mantzios To: pgsql-sql@postgresql.org cc: pgsql-general@postgresql.org Subject: Flight numbers data Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.113 required=5 tests=[AWL=0.113] X-Spam-Score: 0.113 X-Spam-Level: X-Archive-Number: 200603/1392 X-Sequence-Number: 93257 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 have to enter the airports, airport coordinates, countries, airline name, airline code, departure/arrival times, etc...) I found some sources on the web about airlines (codes, names, countries, etc...), also i found about airports, but nothing about flight numbers! This application will be for enterprise (internal) company use, covering the flights of emploees around the world. I was just wondering how internet ticket agents manage to do it. Has anyone from the postgresql camp ever solved such a problem? One point for me, is that my company is doing shipping, and we are not in the travel agents business (IATA, standards etc..) at all, so its hard for me to find the path to follow, and in addition, going the full Travel Agent path would be an overkill, since what we need is just an application for the tickets. It is just that i wanna do it right, maybe play a little bit with AJAX also who knows :) Thanx for any hints. -- -Achilleus