Re: Helper aggregate function

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 <kapustin(dot)sergey(at)gmail(dot)com> 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!
>
>
>
>