Postgres Pro
Downloads
Home   >   mailing lists

Re: *****SPAM***** Re: if-clause to an exiting statement - Mailing list pgsql-general

From Scott Ribe
Subject Re: *****SPAM***** Re: if-clause to an exiting statement
Date
Msg-id 174FCAE5-82B6-44A0-8826-939CA0747BD6@elevated-dev.com
Whole thread Raw
In response to Re: if-clause to an exiting statement  ("kobi.biton" <kobi@comns.co.il>)
Responses Re: *****SPAM***** Re: if-clause to an exiting statement  (Kobi Biton <kobi@comns.co.il>)
List pgsql-general
Tree view 
On Dec 7, 2010, at 4:58 AM, kobi.biton wrote:
>
> hi thanks for the reply I did look at the CASE statement however cannot seem
> to alter the returned row-count ...

Well, yeah. The row count is the count of rows returned. If there are no rows matched by the query, then what exactly
doyou expect to happen? Set the row count to 1, so that the application then tries to access the 1st row of 0??? 

If you need some dummy row returned even in the case where there's no match, then you'll have to construct your query
thatway... 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: dotted quad netmask conversion
Next
From: Peter Eisentraut
Date:
Subject: Re: Type cast removal - proposed exceptions for xml,enum