Hi,
On Tue, Jan 7, 2020 at 2:01 AM Clemens Ladisch wrote:
>
> Richard Hipp wrote:
> > On 1/5/20, Keith Medcalf wrote:
> >> select * from a, b, c using (id); -- very strange result
> >
> > PostgreSQL and MySQL process the query as follows:
> >
> >SELECT * FROM a, (b JOIN c USING(id));
> >
> >
Richard Hipp wrote:
> On 1/5/20, Keith Medcalf wrote:
>> select * from a, b, c using (id); -- very strange result
>
> PostgreSQL and MySQL process the query as follows:
>
>SELECT * FROM a, (b JOIN c USING(id));
>
> SQLite processes the query like this:
>
>SELECT * FROM (a,b) JOIN c USING (
On Sunday, 5 January, 2020 04:42, Richard Hipp wrote:
>On 1/5/20, Keith Medcalf wrote:
>> Hrm. Inconsistent/incorrect results. Consider:
>> create table a(id integer primary key, a);
>> insert into a values (1,1), (2,1), (3,1);
>> create table b(id integer primary key, b);
>> insert into b
> On 1/5/20, Keith Medcalf wrote:
>>
>> Hrm. Inconsistent/incorrect results. Consider:
>>
>> create table a(id integer primary key, a);
>> insert into a values (1,1), (2,1), (3,1);
>> create table b(id integer primary key, b);
>> insert into b values (1,2), (3,2), (4,2);
>> create table c(id int
On 1/5/20, Richard Hipp wrote:
>
> Note that both MySQL and SQLite do allow you to use parentheses, as
> shown in my examples, to define the order of evaluation. PostgreSQL
> does not, sadly.
>
Apparently, in PostgreSQL you have to say:
SELECT * FROM (SELECT * FROM a, b) AS x JOIN c USING(id
On 1/5/20, Keith Medcalf wrote:
>
> Hrm. Inconsistent/incorrect results. Consider:
>
> create table a(id integer primary key, a);
> insert into a values (1,1), (2,1), (3,1);
> create table b(id integer primary key, b);
> insert into b values (1,2), (3,2), (4,2);
> create table c(id integer prima
Hrm. Inconsistent/incorrect results. Consider:
create table a(id integer primary key, a);
insert into a values (1,1), (2,1), (3,1);
create table b(id integer primary key, b);
insert into b values (1,2), (3,2), (4,2);
create table c(id integer primary key, c);
insert into c values (1,3), (4,3),
7 matches
Mail list logo