[GENERAL] Please remove me from the list, thanks

2003-12-20 Thread Mike Hao
_ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=dept/features&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca ---(end

[GENERAL] SELECT ... FOR UPDATE

2003-12-20 Thread Guillaume Houssay
I need som ehelp concerning queries using SLEECT ... FOR UPDATE   I have two tables (see description below)   One is the table of reference, the other one is a table where i have daily infoirmation   I want to check the differences on the two tables based on the fields omc_index and bsc for

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-20 Thread Jeff Davis
> > > > What, exactly, is a partial index? A functional index is an index on > > something like ((ColumnX*2)/14)? I think the functional one (is that > > also an expression index?) is on the way. > > A partial index is a index on a subset of a table. The case I can think of > is a list of trans

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Joshua D. Drake
John Sidney-Woollett wrote: It means that you can create stored procedures/functions which reside in the database that are written in java (as opposed to the native SQL programming language). Why would you want this? If you were more familiar with java than any of the currently supported procedura

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Dave Cramer
I'm actually starting to write one of these for postgres, and apparently there is another one in the works, from Thomas Hallgren. There is at least one significant architectural issue here to deal with Is it more desirable to have a single java vm and communicate via RPC, or some other mechanism?

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Paul Ganainm
[EMAIL PROTECTED] says... > That's a good discussion, but it left out at least one useful bit of > info about managing large objects: there's a contrib utility > (contrib/vacuumlo) that can find and remove large objects that are not > referenced anywhere in the database. What is the URL for

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Paul Thomas
On 20/12/2003 13:05 Shridhar Daithankar wrote: On Saturday 20 December 2003 16:44, John Sidney-Woollett wrote: > It means that you can create stored procedures/functions which reside in > the database that are written in java (as opposed to the native SQL > programming language). Does it mean mysql

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Kris Jurka
On Sat, 20 Dec 2003, Tony (Unihost) wrote: > Can someone a little more clever than I (which means just about anyone > on this list) tell me what the implications/benefits are of this are > please? > > http://developers.slashdot.org/developers/03/12/19/1628241.shtml?tid=108&tid=126&tid=137&tid=1

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Jason Godden
On Sun, 21 Dec 2003 12:05 am, Shridhar Daithankar wrote: > Does it mean mysql got stored procedures? Wow.. > > I would like to see details but since I don't know much details about > either mysql or java, I can not describe it. > > Can anybody give a summary as in how much it takes mysql as far as

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Kris Jurka
On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee wrote: > But unfortunately I could not extract this data to > frontend thru java... I tried in two ways but got the > same error...after getting the data in Blob or Large > Object. > > Error in connection == FastPath call returned ERROR: > inva

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Shridhar Daithankar
On Saturday 20 December 2003 16:44, John Sidney-Woollett wrote: > It means that you can create stored procedures/functions which reside in > the database that are written in java (as opposed to the native SQL > programming language). Does it mean mysql got stored procedures? Wow.. I would like t

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Shridhar Daithankar
On Saturday 20 December 2003 16:44, John Sidney-Woollett wrote: > This would be a "nice to have" for Postgres too - I believe that it > supports PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python at present. http://techdocs.postgresql.org/guides/PLLanguages It is already supported..:-) Shridhar --

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Nilabhra Banerjee
Thanks a lot for the clue... Now I am comfortably handling the Lrge Objects thru SQL... But unfortunately I could not extract this data to frontend thru java... I tried in two ways but got the same error...after getting the data in Blob or Large Object. Error in connection == FastPath call return

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread John Sidney-Woollett
Sorry but I don't know what would be supported. Perhaps someone else can provide more info. Here is a document from Oracle detailing their java stored procedure support: http://otn.oracle.com/tech/java/jroadmap/jsproc/listing.htm#998299 Hope that helps. John Tony (Unihost) said: > Does this in

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Tony (Unihost)
Does this include ALL the functionality of Java?  Objects, Polymorphism, Inheritance, or is it just a subset? T. John Sidney-Woollett wrote: It means that you can create stored procedures/functions which reside in the database that are written in java (as opposed to the native SQL program

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread John Sidney-Woollett
It means that you can create stored procedures/functions which reside in the database that are written in java (as opposed to the native SQL programming language). Why would you want this? If you were more familiar with java than any of the currently supported procedural languages, then it means t

[GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Tony (Unihost)
Can someone a little more clever than I (which means just about anyone on this list) tell me what the implications/benefits are of this are please? http://developers.slashdot.org/developers/03/12/19/1628241.shtml?tid=108&tid=126&tid=137&tid=156&tid=198 Cheers T. ---(e