Search Postgresql Archives

Re: Building a "complex" select?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Nope... It returns 0 rows when there are no rows in log_stop with stoptype = 1...

BTJ

Scott Marlowe wrote:
> On Mon, 2005-04-18 at 11:24, BjÃrn T Johansen wrote:
> 
>>I need a select like this..:
>>
>>select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join log_stop on
>>ordre.id = log_stop.ordreid where ordre.id = 22
>>
>>The problem is that I need to include "where log_stop.stoptype = 1". So if log_stop
>>includes 3 rows with stoptype = 1 and ordreid = 22, my select should return 3 rows.
>>Also, if log_stop includes 3 rows with stoptype = 1 and 2 rows with stoptype = 2, my
>>select should still return 3 rows. And if there are 0 rows with stoptype = 1, my
>>select should return 1 row.
> 
> 
> Would this work?
> 
> select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join log_stop on
> ordre.id = log_stop.ordreid where ordre.id = 22 AND COALESCE(log_stop.stoptype,1)=1
> 
> 

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux