Re: About using plpgsql funciton variable as the table

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: About using plpgsql funciton variable as the table
Date: 2005-08-11 16:20:15
Message-ID: 42FB7ABF.6040104@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Fein 2005-08-11 17:28:44 No PUBLIC access by default?
Previous Message Stephan Szabo 2005-08-11 16:13:12 Re: About using plpgsql funciton variable as the table