On Thu, May 24, 2012 at 1:22 PM, Mike King <mkwi...@gmail.com> wrote:
> Is this Select statement valid? In Oracle, it wouldn't be because
> what is the aggregate of A. Is this behavior defined anywhere?
>
> create table T (A,B);
> insert into T (A,B) values (1,3);
> insert into T (A,B) values (2,3);
>
> select A,B
> from T
> group by B;
>
This is equivalent to the PostgreSQL:
SELECT DISTINCT ON(b) a,b FROM t;
There have been numerous complaints about the syntax and the fact that it
does not generate an error like Oracle, but there are also many legacy
applications that depend on this behavior. So we cannot change it without
breaking applications and causing general grief and woe amongst developers.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
