[SQL] calling webservice through postgresql function

2007-07-13 Thread Jyoti Seth
Hi all, I want to call webservice from my postgresql database. Please let me know if anyone has idea. Thanks, Jyoti Seth

Re: [SQL] calling webservice through postgresql function

2007-07-13 Thread Richard Huxton
Jyoti Seth wrote: Thanks a lot for ur quick response. I have searched a lot on net for code to call a webservice through tcl/tk or any other scripting lang that is supported by postgresql, but couldn't find one. If u can provide me some code to call a web service through postgresql it would be a

Re: [SQL] calling webservice through postgresql function

2007-07-13 Thread Richard Huxton
Jyoti Seth wrote: Hi all, I want to call webservice from my postgresql database. Please let me know if anyone has idea. You can use any of the "untrusted" procedural languages to access resources outside the database (e.g. pl/perlu), or of course C. -- Richard Huxton Archonet Ltd -

Re: [SQL] calling webservice through postgresql function

2007-07-13 Thread Jyoti Seth
Thanks a lot for ur quick response. I have searched a lot on net for code to call a webservice through tcl/tk or any other scripting lang that is supported by postgresql, but couldn't find one. If u can provide me some code to call a web service through postgresql it would be a great help. Thanks,

Re: [SQL] calling webservice through postgresql function

2007-07-13 Thread A. Kretschmer
am Fri, dem 13.07.2007, um 13:01:30 +0530 mailte Jyoti Seth folgendes: > Thanks a lot for ur quick response. I have searched a lot on net for code to > call a webservice through tcl/tk or any other scripting lang that is > supported by postgresql, but couldn't find one. If u can provide me some >

[SQL] calculation of pay based on dates

2007-07-13 Thread Penchalaiah P.
Hi ... I want to fix the pay based on joining date and antedate...antedate is the last date... Joining date is 01-07-2007 Antedate is 04-07-2007.. On joining date I will fix the pay but before fixing the pay I will check whether antedate is there or not, if its there then I will see diffe

Re: [SQL] calculation of pay based on dates

2007-07-13 Thread Gary Stainburn
On Friday 13 July 2007 11:12, Penchalaiah P. wrote: > Hi ... > > I want to fix the pay based on joining date and antedate...antedate is > the last date... > > Joining date is 01-07-2007 > > Antedate is 04-07-2007.. > > > > On joining date I will fix the pay but before fixing the pay I will > check

[SQL] Bitmap Index Scan

2007-07-13 Thread Radhika Sambamurti
I am using Postgres 8.2.0. Is there a way to explicitly make the planner use bitmap index scan on a field? Thanks. Radhika -- It is all a matter of perspective. You choose your view by choosing where to stand. Larry Wall --- ---(end of broadcast)-

Re: [SQL] Bitmap Index Scan

2007-07-13 Thread Rodrigo De León
On 7/13/07, Radhika Sambamurti <[EMAIL PROTECTED]> wrote: Is there a way to explicitly make the planner use bitmap index scan on a field? See: http://www.postgresql.org/docs/8.2/static/runtime-config-query.html ---(end of broadcast)--- TIP 5: do

Re: [SQL] Converting from MS Access field aliases

2007-07-13 Thread Andrej Ricnik-Bay
On 7/13/07, Nis Jørgensen <[EMAIL PROTECTED]> wrote: Don't attribute to malice what can be adequately explained by incompetence. He didn't :) Nis Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm