Re: [GENERAL] origins/destinations

2009-05-21 Thread Carson Farmer
Thanks Andy, That was exactly what I needed! Now I just have to deal with this huge matrix I've generated ;-) Cheers, Carson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] origins/destinations

2009-05-19 Thread denis punnoose
, Carson Farmer wrote: From: Carson Farmer Subject: [GENERAL] origins/destinations To: pgsql-general@postgresql.org Cc: "Carson Farmer" Date: Tuesday, 19 May, 2009, 10:27 PM Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough t

Re: [GENERAL] origins/destinations

2009-05-19 Thread John R Pierce
Andy Colson wrote: Carson Farmer wrote: Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough to get this done: I have a table which is basically a number of individuals with both their origin and destination as columns (see Table

Re: [GENERAL] origins/destinations

2009-05-19 Thread Andy Colson
Carson Farmer wrote: Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough to get this done: I have a table which is basically a number of individuals with both their origin and destination as columns (see Table 1). In this case, o

Re: [GENERAL] origins/destinations

2009-05-19 Thread Andy Colson
Andy Colson wrote: Carson Farmer wrote: Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough to get this done: I have a table which is basically a number of individuals with both their origin and destination as columns (see Table

Re: [GENERAL] origins/destinations

2009-05-19 Thread Richard Huxton
Carson Farmer wrote: Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough to get this done: I have a table which is basically a number of individuals with both their origin and destination as columns (see Table 1). In this case, o

[GENERAL] origins/destinations

2009-05-19 Thread Carson Farmer
Hi list, I have (what I thought was) a relatively simple problem, but my knowledge of sql is just not good enough to get this done: I have a table which is basically a number of individuals with both their origin and destination as columns (see Table 1). In this case, origins and destination