Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] select count(*) from : 0 rows or 1 rows ? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] select count(*) from : 0 rows or 1 rows ?
Date
Msg-id 199905311611.MAA21557@candle.pha.pa.us
Whole thread Raw
In response to select count(*) from : 0 rows or 1 rows ?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
> discovery=> select count(*) from publications;
> count
> -----
>     0
> (1 row)
> 
>   Does 1 rows is a correct result ?
> 
>     Oleg

One row is returned, and that row is zero.  It is correct.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

pgsql-hackers by date:

Previous
From: Mark Volpe
Date:
Subject: New IP address datatype
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] New IP address datatype