Re: [Feature request] variable declaration of anonymous composite data type in PL/pgSQL

Maciej Mrozowski wrote:
> Hello,
>
> Not sure whether it's appropriate list for feature requests though..
> Would it be suitable to implement such variable declarations in PL/pgSQL so 
> that following (or similar) constructs would be possible?
>
> DECLARE
>     tmpStruct (name varchar, foo integer, bar boolean)[] := array[
> ('somename', 1, true),
> ('someothername', 2, false),
> ('yetothername', 3, true)
>     ];
> BEGIN
> ...
>
> Or maybe it is possible already? (I know there are temporary tables but it's 
> not quite the same). The goal to have temporary local random access data 
> structures (like lookup tables), similar to those in C.
>
>   


There have certainly been time I could have used this. You can get close 
using VALUES:
   create or replace function foo()   returns void   language plpgsql as   $$
   declare       rec record;   begin       for rec in         select *         from (values
(1::int,'a'::text,'2009-08-06'::date),            (5,'wxy','1998-12-23'))          as x (a , b , c )       loop
 raise notice 'a: %, b: %, c: %',               rec.a + 1,               length(rec.b),               rec.c + interval
'1day';       end loop;   end;
 
   $$;

cheers

andrew