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: (view raw, whole thread or download thread mbox)
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:
Sent from the PostgreSQL - bugs mailing list archive at

In response to


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-2017 The PostgreSQL Global Development Group