Re: [SQL] Flight numbers data

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: [SQL] results being col wise rather than row wise

On Wed, 29 Mar 2006, Hrishikesh Deshmukh wrote: > HI All, > > I have 5 tables which have different columns as shown below, each table has > a different case column, > i want to retrieve sample related information as follows: > > pid | xindex | yindex | height Index | flag | case1 | case 2.etc

[SQL] results being col wise rather than row wise

HI All, I have 5 tables which have different columns as shown below, each table has a different case column, i want to retrieve sample related information as follows: pid | xindex | yindex | height Index | flag | case1 | case 2.etc But i get this queer result: pid    | xindex | yindex |

Re: [SQL] Ugly group by problem

On 29 mar 2006, at 17.42, Achilleus Mantzios wrote: The _int_union trick is to force the arrays to have unique values. The order by has the meaning that '{5,23}' and '{23,5}' should be treated the same way. I didn't have the _int_union function. Is it internal? What PG- version did you use

[SQL] Getting more information about errorcodes such as when these error1 happen

Good morning, In my plpgsql functions I use "exception when..." to catch possible exceptions of my data. I found postgresql error code track functions are very helpful. In my functions, I will not catch all error codes, but only the ones applying to my data operation . I found errorcodes in

Re: [SQL] Flight numbers data

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

Re: [SQL] Ugly group by problem

O Markus Schaber έγραψε στις Mar 29, 2006 : > Hello, > > I have a table filled from third party that basically has the following > structure: > > link_id | feat_id | other | columns... > +-+---+--- > 1 | 2 | ... > 2 | 5 | ... > 2 | 23

[SQL] Ugly group by problem

Hello, I have a table filled from third party that basically has the following structure: link_id | feat_id | other | columns... +-+---+--- 1 | 2 | ... 2 | 5 | ... 2 | 23 | ... 3 | 5 | ... 3 | 23 | some | data

[SQL] Flight numbers data

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, ai