On 08/23/2012 04:12 AM, Denis Kolesnik wrote:
Suppose a person who has basic SQL knowledges would learn on praxis
how would result a query if a person adds the clause "limit 1" to it
Then they just got bitten by not learning enough and not testing their
code well enough; they were probably pr
Denis Kolesnik writes:
> You would sugguest, that one should read documentation.
Indeed.
> in the (where with ... replaced a directory in which the PostgreSQL installed)
> ...PostgreSQL\9.1\doc\postgresql\html\queries-limit.html
> "...When using LIMIT, it is important to use an ORDER BY clause
My arguments are:
is that even
select id, str_last_name from tbl_owners_individual where id in
(83,175,111,1) order by id;
id |str_last_name
-+--
1 | Kolesnik
83 | GX
111 | Kolesnik
175 | GX
(4 строки)
select id, str_last_name from tbl_owners
Denis Kolesnik wrote:
> My arguments are:
>
> is that even
> select id, str_last_name from tbl_owners_individual where id in
> (83,175,111,1) order by id;
>
> id |str_last_name
> -+--
>1 | Kolesnik
> 83 | GX
> 111 | Kolesnik
> 175 | GX
> (