Skip site navigation (1) Skip section navigation (2)

Re: how to proccess record returning null

From: te <tejal_1910(at)yahoo(dot)co(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: how to proccess record returning null
Date: 2012-09-14 15:31:37
Message-ID: 1347636697274-5724061.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Sorry I didnt mention it.

temp is a table name. 

FOR r in select distinct(id) from temp

There are no distinct id's in table 'temp', so record 'r' has null values.

So I guess the control is not going inside the loop.

Any suggestions?




--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-proccess-record-returning-null-tp5723932p5724061.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-09-14 16:45:35
Subject: Re: BUG #7539: Result mismatch on Postgres 9.2.0
Previous:From: Marko TiikkajaDate: 2012-09-14 15:26:29
Subject: Re: BUG #7516: PL/Perl crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group