Re: Function with Integer array parameter - Mailing list pgsql-general

On Thu, Aug 16, 2007 at 11:14:25AM -0400, Ranjan Kumar Baisak wrote:
> Postgres Gurus,
>                             Please suggest me what is wrong with this
> function.
> This function tries to retrieve set of rows from description table based
> on set of ID fields passed as array.
>
> The error, I get is : ERROR:  only one AS item needed for language "plpgsql"
>
> CREATE OR REPLACE function get_description_list(integer[]) RETURNS SETOF
> type_description AS
> 'DECLARE
...
>        WHERE   d_base.id in array_to_string(ints_desc_ids alias,',')

Note the quotes.

Use dollar quoting... it$$s your friend.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)