Hi,
I've got PsotgreSQL 7.3.
My problem is joins. I've seen the syntax on joins and have sucessefully
used SQLs with joins, but I've got some other big SQL statements using many
and complex
joins.
Simplified example:
select G.SELID, G.TEXT,
L.ID as SELLEVELID , L.SELLEVEL, L.LEVEL
Password: d5B9Av
Hi,
I've got PsotgreSQL 7.3.
My problem is joins. I've seen the syntax on joins and have sucessefully
used SQLs with joins, but I've got some other big SQL statements using many
and complex
joins.
Simplified example:
select G.SELID, G.TEXT,
L.ID as SELLEVELID ,
On Mon, 24 Mar 2003, Correia, Carla wrote:
>
> Hi,
>
> I've got PsotgreSQL 7.3.
>
> My problem is joins. I've seen the syntax on joins and have sucessefully
> used SQLs with joins, but I've got some other big SQL statements using many
> and complex
> joins.
> Simplified example:
>
> selec
:[EMAIL PROTECTED]
Gesendet: Monday, March 24, 2003 11:44 AM
Cc: '[EMAIL PROTECTED]'
Betreff: Re: [SQL] Complex outer joins?
On Mon, 24 Mar 2003, Correia, Carla wrote:
>
> Hi,
>
> I've got PsotgreSQL 7.3.
>
> My problem is joins. I've seen the syntax on joins
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On 26 Mar 2003, Greg Stark wrote:
>> Can you show an example where the join order would affect the result set? I
>> can't think of any.
> I can think of a few somewhat degenerate cases.
I don't think you need a degenerate case. Consider
from (G le
Hi...
Postgres 7.3
I'm using the copy command to fill my tables. I've got this file with the
data with delimiter '\t' and 'isnull' for nulls as follows:
copy mytable FROM
'/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t'
with null as 'isnull';
But I receive an
On Wed, 26 Mar 2003, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On 26 Mar 2003, Greg Stark wrote:
> >> Can you show an example where the join order would affect the result set? I
> >> can't think of any.
>
> > I can think of a few somewhat degenerate cases.
>
> I don't think y
Tom Lane <[EMAIL PROTECTED]> writes:
> The SQL-standard way of writing this would presumably be either
>
> from G left join L on (G.SELID = L.SELID)
> left join C on (L.SELID = C.SELID and L.SELLEVEL = C.SELLEVEL)
I would think of it as this one.
> from G left join
> (
