hi in this case you have to use execute:
>> select $1,count(*) from $2 group by $1 order by $1; execute into myResultSet 'select ' || $1 || ' from ' || $2 || ' group by ' || $1 || ' order by ' || $2; see plpgsql docs for detailed information christian On Sun, February 3, 2008 19:58, Robins Tharakan wrote: > Please correct me if I am wrong, but as the last few lines of the first > section in the given document says, you can use $n only for values and not > for identifiers. > > http://www.postgresql.org/docs/8.3/static/xfunc-sql.html > > And one more thing, may be you would want to use a user-defined return > type > instead of void for this function. > > *Robins* > > On Feb 3, 2008 5:14 PM, sergey kapustin <[EMAIL PROTECTED]> wrote: > >> Hello! >> Can anyone tell me how i do this properly? >> >> create or replace function agg(varchar,varchar) returns void as $func$ >> select $1,count(*) from $2 group by $1 order by $1; >> $func$ >> Language SQL; >> >> Right now this wives me "ERROR: syntax error at or near "$2" at >> character >> 97 >> select $1,count(*) from $2 group by $1 order by $1;" >> >> Thank you! >> >> >> >> > -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
