Re: Need help in spi_prepare errors - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Need help in spi_prepare errors
Date
Msg-id 20091007142434.GC7719@alvh.no-ip.org
Whole thread Raw
In response to Re: Need help in spi_prepare errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Need help in spi_prepare errors
List pgsql-general
Tom Lane escribió:

> I'm not much of a Perl hacker, but I seem to recall that it's possible
> to pass an array to a function in a way that will make the array
> elements look like separate arguments.  If you really need a dynamic
> list of types and values, maybe there's some solution in that direction.

Actually any time you pass an array as a parameter, the list is
flattened and the function sees it as a plain list.  If that doesn't
seem to make sense, consider that if you pass two lists they will be
flattened to a single list and you won't be able to tell where one
ends and the other starts.

If you really want two separate lists, you need to pass them as array
references (i.e. \@myarray).  I guess you could also pass an element
count but that's not very perlish.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump with 1100 schemas being a bit slow
Next
From: Kynn Jones
Date:
Subject: How to troubleshoot authentication failure?