Re: Table name as parameter in function

Tim,

I'm afraid, I didn't get the point. Could you give me an example code
snippet of how to use the EXECUTE command in my case. Do I have to use
the EXECUTE within my function?

Thanks a lot,
alex.

Timothy Perrigo wrote:

> You'll need to use the EXECUTE command to build the SQL dynamically.
>
> See:
> http://www.postgresql.org/docs/7.4/interactive/plpgsql-
> statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> On Nov 23, 2004, at 2:56 PM, Alexander Pucher wrote:
>
>> Hi,
>>
>> struggling around with this for some time:
>>
>> How can I use a table name as a parameter in a PL/pgSQL function ??
>>
>> I tried this but it didn't work...
>>
>>
>> CREATE OR REPLACE FUNCTION my_row_count(text) RETURNS int4 AS '
>> DECLARE
>>    num_rows int4;
>> BEGIN
>>    num_rows := (select count(*) from $1);
>>    RETURN num_rows;
>> END;
>> ' LANGUAGE plpgsql;
>>
>> Thnaks for any input!
>>
>> regards,
>> alex.
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>

--
--------------------------------------------------------
Departement of Geography and Regional Research
University of Vienna
Cartography and GIS
--------------------------------------------------------
Virtual Map Forum: http://www.gis.univie.ac.at/vmf
--------------------------------------------------------