[GENERAL] How to use Integer array in where IN clause parameter

Hello, Can anybody suggest me how to use Integer array inside a function in where IN clause. In my function, I have used it like WHERE d_base.id in (|array_to_string| (integer_array, ',')) However it does not work. ANy suggestion?

Re: [GENERAL] Function with Integer array parameter

Decibel! wrote: 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

[GENERAL] Function with Integer array parameter

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

[GENERAL] autoReconnect with PostGres

Hello Group, I am using postgres in my web application. Number of physical DB connections are just getting increased for each re-deployment of my web application. I generally dont shutdown my webserver and only re-deploy my web application. I heard that "autoReconnect = tr

[GENERAL] Disadvantage of SQL Joins

Can anybody please tell me whether there are any disadvantage of SQL joins in terms of space and time and how postgres has implemented SQL joins? I am in the impression that SQL join takes more time for execution as well as space because database internally builds Cartesian product and then eva

Re: [GENERAL] DB crashed

Thomas H. wrote: post some more informations, i.e. version, latest entries in logfile before crash, etc. - thomas - Original Message - *From:* rbaisak *To:* pgsql-general@postgresql.org *Sent:* Monday