Re: [HACKERS] Should the following work...?

From: Clark Evans <clark(dot)evans(at)manhattanproject(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Should the following work...?
Date: 1999-03-30 18:34:40
Message-ID: 37011940.8C70AE72@manhattanproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker wrote:
>
> select id
> from clients
> where id = ( select id
> from clients
> where count(id) = 1 ) ;
>

What are you trying to do, grab the id
of the first row in the table?

If this is so, try:

select id from clients limit 1;

Otherwise, I can't figure out what
the above code is trying to accomplish.

Best,

Clark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1999-03-30 18:44:34 RE: [HACKERS] Should the following work...?
Previous Message The Hermit Hacker 1999-03-30 18:27:20 RE: [HACKERS] Should the following work...?