Re: Helper aggregate function
| От | Robins Tharakan |
|---|---|
| Тема | Re: Helper aggregate function |
| Дата | |
| Msg-id | 36af4bed0802031058j4ce4be26p111d0071bf31d5a0@mail.gmail.com обсуждение |
| Ответ на | Helper aggregate function ("sergey kapustin" <kapustin.sergey@gmail.com>) |
| Список | pgsql-sql |
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
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.sergey@gmail.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!
В списке pgsql-sql по дате отправления: