[GENERAL] how to pass an array to the plpgsql function from Java Code

how to pass an array to the plpgsql function from Java Code ?? say from a JDBC preparedStatement Example :- create or replace function test( x integer[] ) returns integer as $BODY$ BEGIN RETURN x[0]; END ; language 'plpgsql' JDBC CODE :- int [] ar = {1,2,3}; PreparedStament pre= connec

Re: [GENERAL] Has anyone used the libpqxx C++ API for PostgreSQL

, or know who I should ask, I'd appreciate it. Thanks, Andy ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Sandeep Kumar Jakkaraju WeBlog:

[GENERAL] Too many open cursors

true or ...mine can be a special case !!??? -- Sandeep Kumar Jakkaraju  

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

aul Ramsey <[EMAIL PROTECTED]> wrote: Any one you want.  Using the latest won't hurt.On 6-Nov-06, at 11:36 AM, Sandeep Kumar Jakkaraju wrote:What version of Postgis should i install for postgres 8.1.5 ??On 11/7/06, Paul Ramsey < [EMAIL PROTECTED] > wrote:PgSQL 7.4 is still sup

[GENERAL] what version of Postgis should i install for Postgres-8.1.5 RHEL 4 -AS RPM

what version of Postgis should i install for Postgres-8.1.5 ?? And where can i find its RPM for RHEL 4 -AS ...??? Thanks in advance -- Sandeep Kumar Jakkaraju WeBlog:http://jakkarajus.blogspot.com

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

t; Thanks>> Regards>> Sandeep>>>>>> On 11/6/06, Devrim GUNDUZ <[EMAIL PROTECTED] > wrote:>>>>>> Hi,>>>>>> On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:>>>> The site u gave me has ..>>>>

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

Ya...That was my next question ... if i build the source (the tar.gz) on the postgis.org site ..will it be compatible with... postgres-8.1.5ThanksRegardsSandeep On 11/6/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: Hi,On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:> T

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

Hi Dev,The site u gave me has ..has postgis rpm ..but it needs postgres-7.4 !! i need postgis rpm for postgres-8.1.5ThankssandeepOn 11/4/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: Hello,On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote:> I am unable to find PostGIS B

[GENERAL] PostGIS Binary RPM for Red Hat Linux

Hi All     I am unable to find PostGIS Binary RPM for Red Hat Linux ...on the  postgis.org website ...   Can somebody point me to the url from where i can download ...this ??   Thanks in advance   Sandeep  

Re: [GENERAL] PostGIS

ns.>> The Refractions site already noted is a good start. The MapServer> site is another:>> http://mapserver.gis.umn.edu/gallery>> Jim>> ->> James Cradock, [EMAIL PROTECTED] [EMAIL PROTECTED]>>>>>>> --> Sandeep Kumar

[GENERAL] Is postgres installed by default in Fedora Core 5 ??

Is postgres installed by default in Fedora Core 5 ??   - Sandeep Kumar Jakkaraju  

Re: [GENERAL] PostGIS

-- Sandeep Kumar Jakkaraju WeBlog:http://jakkarajus.blogspot.com

[GENERAL] Is it possible to port from Postgres to Versant

Is it possible to port from Postgres tables  to Versant   - sandeep

[GENERAL] Is Postgres good for large Applications

Hi All Is Postgres good for large Applications ?? I mean where we have to make many simulataneous connections... Thanks Sandeep ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Connection Pooling for Postgres

Hi All Is there any inbuilt facility in postgres for connection pooling .. ?? Thanks - sandeep ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] Can we convert from Postgres to Oracle !!???

Can we convert from Postgres to Oracle !!??? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Troubles linking with libpqxx

Hi Eric Check your Runtime Library( MultiThreaded Debug Dll  etc)  and Struct member alignment !!!They should be same as what you used to compile libpqRegardssandeep On 8/16/06, Eric <[EMAIL PROTECTED]> wrote: Hi,I'm trying to compile the test001.cxx sample included in thelibpqxx-2.6.7 package, but

Re: [GENERAL] Connection Object

E)   I hope this helps  On 8/12/06, Sandeep Kumar Jakkaraju < [EMAIL PROTECTED]> wrote: Hi All I want to know specifically from the exception thrown by the "connection" object when the connnection string is wrong..whether it is due to wrong database name or wrong user name or wr

[GENERAL] Connection Object

Hi All I want to know specifically from the exception thrown by the "connection" object when the connnection string is wrong..whether it is due to wrong database name or wrong user name or wrong password !!! Is it possible ??Thanx in advance-- Sandeep Kumar Jakkaraju W

[GENERAL] Help

DEBUG and RELEASE problem of LIBPQ DLLs   Please help !!!     -- Sandeep Kumar Jakkaraju WeBlog:http://jakkarajus.blogspot.com