What I want to do is,
CREATE OR REPLACE FUNCTION clean()
RETURNS void AS $$
DECLARE
r record;
BEGIN
FOR r in select distinct(id) from temp
loop
If r.id is null or r.id ='' Then
Insert into table_1 select * from temp;
else
Insert into table_1 select * from temp where
sequence_number=r.id;
end if;
end loop;
END;
$$ LANGUAGE plpgsql;
If 'id' is null then I want to insert all the records from table 'temp' to
'table_1'
But if 'id' is not null I want to insert the data corresponding to those
id's from table 'temp' to 'table_1'.
Since id's are null or empty sting, control is not going inside the loop and
as a result no data is inserted from table 'temp' to table 'table_1'.
Currently I have come up with following workaround where null value is
checked separately out of loop.
CREATE OR REPLACE FUNCTION clean()
RETURNS void AS $$
DECLARE
r record;
BEGIN
if (select distinct(id) from temp ) is null
then Insert into table_1 select * from temp;
end if;
FOR r in select distinct(id) from temp
loop
Insert into table_1 select * from temp where
sequence_number=r.id;
end loop;
END;
$$ LANGUAGE plpgsql;
But I think this is inefficient way of coding.
Do you have any better alternative to this ?
I hope I am clear.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-proccess-record-returning-null-tp5723932p5724361.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
