Request a Demo
Home   >   mailing lists

Re: Helper aggregate function - Mailing list pgsql-sql

From Robins Tharakan
Subject Re: Helper aggregate function
Date
Msg-id 36af4bed0802031058j4ce4be26p111d0071bf31d5a0@mail.gmail.com
Whole thread Raw
In response to Helper aggregate function  ("sergey kapustin" <kapustin.sergey@gmail.com>)
List pgsql-sql
Tree view
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.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 by date:

Previous
From: "sergey kapustin"
Date:
Subject: Helper aggregate function
Next
From: "Christian Kindler"
Date:
Subject: Re: Helper aggregate function