Yelai,
The etiquette on this list is to place all replies either in-line (but
following the content being quoted) or at the end of the posting.
My reply is at the end.
=By: Sergey Konoplev
If you do not need information about column types you can use hstore for
this purpose.
[local]
sage-
From: gray...@gmail.com [mailto:gray...@gmail.com] On Behalf Of Sergey Konoplev
Sent: Tuesday, September 04, 2012 3:27 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Need to Iterate the record in plpgsql
If you do not need information about column types you can
& Regards,
Ramkumar
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Tuesday, September 04, 2012 11:52 AM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Need to Iterate the record in plpgsql
Hello
http://okbob.blogspot.cz/201
If you do not need information about column types you can use hstore
for this purpose.
[local]:5432 grayhemp@grayhemp=# select * from r limit 1;
a | b | c
---+---+---
1 | 2 | 3
(1 row)
[local]:5432 grayhemp@grayhemp=# select * from each((select hstore(r)
from r limit 1));
key | value
-+---
Hello
http://okbob.blogspot.cz/2010/12/iteration-over-record-in-plpgsql.html
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger
Regards
Pavel Stehule
2012/8/31 Yelai, Ramkumar IN BLR STS :
> Hi All,
>
> I am facing a issue in Iterating the RECORD.
>
> Th
Hi All,
I am facing a issue in Iterating the RECORD.
The problem is, I would like to iterate the RECORD without using sql query, but
as per the syntax I have to use query as shown below.
FOR target IN query LOOP
statements
END LOOP [ label ];
In my procedure, I have stored one of the proce
