How I write pretty query

From: Rado Petrik <r(dot)p(at)szm(dot)sk>
To: PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org>
Subject: How I write pretty query
Date: 2003-04-29 17:46:05
Message-ID: 1051638365.775.95.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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-04-29 17:55:00 Re: How I write pretty query
Previous Message SZŰCS Gábor 2003-04-29 16:03:48 Re: Query Plan far worse in 7.3.2 than 7.2.1