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

Re: plpgsql : adding record variable to table

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: thomas veymont <thomas(dot)veymont(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql : adding record variable to table
Date: 2012-04-18 18:03:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

please try:

postgres=# create or replace function foo()
returns void as $$
declare r x;
  for r in select * from x
    insert into y values(r.*);
  end loop;
$$ language plpgsql;



2012/4/18 thomas veymont <thomas(dot)veymont(at)gmail(dot)com>:
> (sorry my previous email was truncated)
> hi,
> Here is what I want to do :
> I want to check each row of a table against some conditions (this
> check needs some
> processing stuff I can easily code with pl/pgsql).
> If the row is OK, I want to add it in a "resulting table",
> else I just ignore the current row and go to next one.
> My function looks like this : (simplified)
> FUNCTION myfunction (...)  RETURNS TABLE ( elem1 , elem2, elem3 ...)
>   g RECORD
>  FOR g in SELECT colum1, column2, ... FROM someTable
>   LOOP
>      -- do some processing on "g", then decide wheter I want to
> select it or not
>     IF (g is selected) THEN >>add g to resulting_table<<
>  RETURN resulting_table
> How should I write the "add g to resulting table" part ?
> thanks,
> Tom
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-sql by date

Next:From: thomas veymontDate: 2012-04-19 09:43:05
Subject: Re: plpgsql : adding record variable to table
Previous:From: thomas veymontDate: 2012-04-18 17:55:55
Subject: plpgsql : adding record variable to table

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