[SQL] calling webservice through postgresql function
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
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 great help. Just use pl/perlu (or pythonu or tclu) in whatever way you would normally "call a webservice". That side of things has nothing to do with PG (other than the fact that it will hold up your query). If you don't know how to "call a webservice" then you'll need to check with one of the developer forums for your language of choice I'm afraid. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [SQL] calling webservice through postgresql function
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [SQL] calling webservice through postgresql function
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, Jyoti Setj -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 12:57 PM To: Jyoti Seth Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] calling webservice through postgresql function 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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [SQL] calling webservice through postgresql function
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 > code to call a web service through postgresql it would be a great help. As Richard says, use an untrusted language like pl/perlU (U means untrusted) to call arbitrary external programs. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[SQL] calculation of pay based on dates
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 difference between 2 dates..if difference is 2 years then I will fix the pay with increments...if difference is less than 2 years then I will fix the pay with out increments... Take an example of above 2 dates..there is no 2 years difference between two dates... 01-07-2007 I will fix the pay...after 3 days current date = antedate...so again I have to fix the pay with out my intervention... Is there any jobs or schedules or triggers to call that function when current date and antedate is equal... Any one can help on this... I need it very soon Regards Penchal Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] calculation of pay based on dates
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 whether antedate is there or not, if its there then I will see > difference between 2 dates..if difference is 2 years then I will fix the > pay with increments...if difference is less than 2 years then I will fix > the pay with out increments... > > Take an example of above 2 dates..there is no 2 years difference between > two dates... > > 01-07-2007 I will fix the pay...after 3 days current date = > antedate...so again I have to fix the pay with out my intervention... > > Is there any jobs or schedules or triggers to call that function when > current date and antedate is equal... > > > > Any one can help on this... I need it very soon > > > Regards > Penchal > Surely this would easiest be done using a view rather than a trigger or function. Simply have the salary calculated every time the view is selected. -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[SQL] Bitmap Index Scan
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)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [SQL] Bitmap Index Scan
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: don't forget to increase your free space map settings
Re: [SQL] Converting from MS Access field aliases
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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
