On 04/06/2012 01:46 PM, Pavel Stehule wrote:
2012/4/6 Rob Sargent:
On 04/06/2012 01:23 PM, Pavel Stehule wrote:
Hello
2012/4/6 Andreas:
hi,
is there a disadvantage to write a join as
select *
froma, b
where a.id = b.a_id;
over
select *
froma join b on a.id = b.a_id;
2012/4/6 Rob Sargent :
> On 04/06/2012 01:23 PM, Pavel Stehule wrote:
>>
>> Hello
>>
>> 2012/4/6 Andreas:
>>>
>>> hi,
>>>
>>> is there a disadvantage to write a join as
>>>
>>> select *
>>> from a, b
>>> where a.id = b.a_id;
>>>
>>
>>> over
>>>
>>> select *
>>> from a join b on a.id =
On 04/06/2012 01:23 PM, Pavel Stehule wrote:
Hello
2012/4/6 Andreas:
hi,
is there a disadvantage to write a join as
select *
froma, b
where a.id = b.a_id;
over
select *
froma join b on a.id = b.a_id;
yes - newer notation has some advantages
* clean specification join p
Hello
2012/4/6 Andreas :
> hi,
>
> is there a disadvantage to write a join as
>
> select *
> from a, b
> where a.id = b.a_id;
>
> over
>
> select *
> from a join b on a.id = b.a_id;
>
yes - newer notation has some advantages
* clean specification join predicate and filter predicate
hi,
is there a disadvantage to write a join as
select *
froma, b
where a.id = b.a_id;
over
select *
froma join b on a.id = b.a_id;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
