Re: [HACKERS] Should the following work...?

Поиск
Список
Период
Сортировка
От Clark Evans
Тема Re: [HACKERS] Should the following work...?
Дата
Msg-id 37011940.8C70AE72@manhattanproject.com
обсуждение исходный текст
Ответ на Should the following work...?  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
The Hermit Hacker wrote:
> 
> select id
>   from clients
>  where id = ( select id
>                 from clients
>                where count(id) = 1 ) ;
> 

What are you trying to do, grab the id 
of the first row in the table?

If this is so, try:
select id from clients limit 1;

Otherwise, I can't figure out what
the above code is trying to accomplish.

Best,

Clark


В списке pgsql-hackers по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: RE: [HACKERS] Should the following work...?
Следующее
От: The Hermit Hacker
Дата:
Сообщение: RE: [HACKERS] Should the following work...?