Skip site navigation (1) Skip section navigation (2)

Re: calling function

From: Bhushan Bhangale <bbhangale(at)Lastminute(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: calling function
Date: 2004-03-02 15:44:51
Message-ID: C9590F897BFAD7119E63000BCD6820830165944A@lmnukpriv.lastminute.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Tom,

Well actually it worked via java now.

But I am really interested in what you said about first call.

I am creating the temp_accomm table everytime I call the function and drop
it in the end.

Let me explain the functionality. I need to get the result of a query which
joins 4 tables. The problem is because of this join I get more than one
record for one accomodation which is fine as there are multiple child images
for a accomm. What I have to do is concatenate the column of image table and
return in the resultset.

The out put looks like this

412|Hotel Cristallo|0|0|901#902|r82h06.jpg#r82h06.jpg|Hotel Cristallo#Hotel
Cristallo
413|Campo Smith Village|0|0|903#904|r83a06.jpg#r83a06.jpg|Campo Smith
Village and Great Western Hotel Rive#Campo Smith Village and Great Western
Hotel Rive

Do you still see any problem here.

One more thing in MS-SQL I used to create temp table using #. How can I do
that here in postgres?

Thanks
Bhushan

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 02 March 2004 15:16
To: Bhushan Bhangale
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] calling function 


Bhushan Bhangale <bbhangale(at)Lastminute(dot)com> writes:
> Error: ERROR:  relation with OID 659490 does not exist (State:S1000,
Native
> Code: 7)

That function is only going to work once per session, because plpgsql
caches query plans.  After the first call, the commands in the loop will
refer to a version of temp_accomm that doesn't exist anymore.

AFAICS you do not actually need the temp_accum table anyway.  Why don't
you just return the data directly from the main loop?

			regards, tom lane

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

pgsql-jdbc by date

Next:From: Sean ElliottDate: 2004-03-02 17:07:35
Subject: Passing parameters to functions from Java
Previous:From: Tom LaneDate: 2004-03-02 15:15:52
Subject: Re: calling function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group