From: Robins Tharakan <tharakan@gmail.com>
To: sergey kapustin <kapustin.sergey@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Helper aggregate function
Date: Mon, 4 Feb 2008 00:28:00 +0530
Message-ID: <36af4bed0802031058j4ce4be26p111d0071bf31d5a0@mail.gmail.com> (raw)
In-Reply-To: <cf82f1380802030344x10138291ob685533ef4b5a4c8@mail.gmail.com>
References: <cf82f1380802030344x10138291ob685533ef4b5a4c8@mail.gmail.com>
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!
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tharakan@gmail.com, kapustin.sergey@gmail.com
Subject: Re: Helper aggregate function
In-Reply-To: <36af4bed0802031058j4ce4be26p111d0071bf31d5a0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox