From: Richard Grosse <lists@keep-trying.com>
To: pgsql-sql@postgresql.org
Subject: Re: Converting query to view - duplicate fields - solved
Date: Wed, 10 Mar 2004 22:51:03 +0000
Message-ID: <6.0.0.22.0.20040310224936.01ccda30@192.168.5.1> (raw)
In-Reply-To: <20040309181341.S12789@megazone.bigpanda.com>
References: <6.0.0.22.0.20040309223517.0351e328@192.168.5.1>
<20040309181341.S12789@megazone.bigpanda.com>
At 02:17 10/03/2004, you wrote:
>On Tue, 9 Mar 2004, Richard Grosse wrote:
>
> > Trying to convert the query below to a view. The problem is
> > despite it working as a query when trying to save it as a
> > view the database returns the error that the field tablealias.cmpname
> > is duplicated. (Which it is and has to be)
>
>You're going to need to use column aliases to alias (for example)
>tbldeliver.cmpname, tblsender.cmpname, tblhaulier.cmpname to different
>aliases in the view, perhaps
>"tbldeliver.cmpname" "tblsender.cmpname" and "tblhaulier.cmpname"
>(note the double quotes).
Great just what I needed to know. Works fine now :-)
Thanks
Richard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lists@keep-trying.com
Subject: Re: Converting query to view - duplicate fields - solved
In-Reply-To: <6.0.0.22.0.20040310224936.01ccda30@192.168.5.1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox