Re: About using plpgsql funciton variable as the table - Mailing list pgsql-general

From Richard Huxton
Subject Re: About using plpgsql funciton variable as the table
Date
Msg-id 42FB7ABF.6040104@archonet.com
Whole thread Raw
In response to About using plpgsql funciton variable as the table name  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-general
Ying Lu wrote:
> Greetings,
>
> I met a question about how to use *function variable *as the *table
> name* to select count(*) into an integer variable for the table.

Look at: FOR-IN-EXECUTE

http://www.postgresql.org/docs/8.0/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Exceptions in PL/Perl?
Next
From: Stephan Szabo
Date:
Subject: Re: About using plpgsql funciton variable as the table