I did say untested :)
-- Original Message ---
From: Michael Fuhr <[EMAIL PROTECTED]>
To: Jim Buttafuoco <[EMAIL PROTECTED]>
Cc: Frodo Larik <[EMAIL PROTECTED]>, pgsql-general@postgresql.org
Sent: Fri, 25 Mar 2005 09:05:50 -0700
Subject: Re: [GENERAL] Stuck wit
On Fri, Mar 25, 2005 at 10:37:31AM -0500, Jim Buttafuoco wrote:
>
> try the following (untested) query:
>
> SELECT la.name,lb.name pp.distance FROM payway_profile AS pp
> JOIN location AS la ON ( pp.location_a = l.location_id )
> join location AS lb ON ( pp.location_b = l.location_id );
This que
gt;
To: pgsql-general@postgresql.org
Sent: Fri, 25 Mar 2005 16:04:17 +0100
Subject: [GENERAL] Stuck with references
> Hello all,
>
> this is my first post to the list, so please be gentle :-)
>
> I created the following tables (full file can be found here:
> http://www
Hello all,
this is my first post to the list, so please be gentle :-)
I created the following tables (full file can be found here:
http://www.larik.nl/sql/payway.sql ):
CREATE TABLE location (
location_id integer DEFAULT nextval('"location_id_seq"'::text) NOT NULL,
name text NOT NULL,
CONST
