From: | Radovan Petrikí <r(dot)petrik(at)episoftware(dot)com> |
---|---|
To: | PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org> |
Subject: | How I write pretty query. |
Date: | 2003-04-29 15:49:37 |
Message-ID: | 1051631377.3674.35.camel@caj |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | SZŰCS Gábor | 2003-04-29 16:03:48 | Re: Query Plan far worse in 7.3.2 than 7.2.1 |
Previous Message | Tom Lane | 2003-04-29 14:53:13 | Re: Query Plan far worse in 7.3.2 than 7.2.1 |