| 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: | Whole Thread | Raw Message | 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 |