How I write pretty query.

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

Browse pgsql-sql by date

  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