From: Christian Kindler <christian.kindler@gmx.net>
To: robins@pobox.com
Cc: sergey kapustin <kapustin.sergey@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Helper aggregate function
Date: Sun, 03 Feb 2008 21:07:05 +0100
Message-ID: <20080203200705.17830@gmx.net> (raw)
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 <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!
>>
>>
>>
>>
>
--
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
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: christian.kindler@gmx.net, robins@pobox.com, kapustin.sergey@gmail.com
Subject: Re: Helper aggregate function
In-Reply-To: <20080203200705.17830@gmx.net>
* 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