Re: creating a function with a variable table name

> dp'>     HAVING sum(dst_packets)>0
> dp'>     ORDER BY sum(dst_packets) DESC;'
> dp-> LANGUAGE SQL;
> ERROR:  syntax error at or near "$2" at character 179
> LINE 6:       FROM $2
>                    ^
> How can I pass the table name?

Look at the EXECUTE option in plpgsql.

Joshua D. Drake



>
> Thanks!
> George
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/