X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 61769475B47
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 13:50:06 -0400 (EDT)
Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150])
	by postgresql.org (Postfix) with ESMTP id 5E92F475B47
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 13:49:30 -0400 (EDT)
Received: from [193.58.192.97] (helo=juice)
	by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19AYzL-0004Xd-00
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 19:33:55 +0200
Received: from localhost.localdomain ([192.168.1.25]) by juice
	for pgsql-sql@postgresql.org; Tue, 29 Apr 2003 19:46:06 +0200
Subject: How I write pretty query
From: Rado Petrik <r.p@szm.sk>
To: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 29 Apr 2003 19:46:05 +0200
Message-Id: <1051638365.775.95.camel@caj>
Mime-Version: 1.0
X-Spam-Status: No, hits=-8.1 required=5.0
	tests=BAYES_20,NO_DNS_FOR_FROM,USER_AGENT_XIMIAN
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/428
X-Sequence-Number: 13129



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