How I write pretty query
| От | Rado Petrik |
|---|---|
| Тема | How I write pretty query |
| Дата | |
| Msg-id | 1051638365.775.95.camel@caj обсуждение исходный текст |
| Ответы |
Re: How I write pretty query
|
| Список | pgsql-sql |
Hi ,
I have table
------------------
id | name
------------------
1 rado
2 marek
3 pista
I need make query. Your output is only (true or false)
This 2 query are good but no pretty.
1) SELECT COUNT(*) FROM table WHERE name=rado
------------- output --> COUNT(*) 1
or
2) SELECT name FROM table WERE name=rado
------------- output --> name rado
and this is pretty query :-) buy no good.
SELECT (true or false) FROM table WHERE name=rado
-------------- output ----> true
How I write good and pretty query ?
Thanks
Rado
В списке pgsql-sql по дате отправления: