Re: [SQL] plpgsql

2000-12-11 Thread Kovacs Zoltan Sandor
> Hi, there, > > Is there any way to handle exception ( such as cannot insert duplicate key on > a unique index) in > plpgsql function? > > I don't want it abort whole transaction instead I want to do something else if > it happened, > but I don't want to use a select stmt first to waste the tim

Re: [SQL] Where Can I find JDBC driver.

2000-12-11 Thread Robert B. Easter
On Monday 11 December 2000 11:45, Mateusz Mazur wrote: > Hello. > I wonder where I can find JDBC driver for Postgresql. I think it should be > class (sorry I am newbie). I would be very greatfull for quick response. > > Mateusz. /usr/src/postgresql-7.0.3/src/interfaces/jdbc Its with the source.

Re: [SQL]

2000-12-11 Thread Joseph Shraibman
No. > Peeter Smitt wrote: > > Hi > > Is it somehow possible to join tables from multiple databases into one > query? > > Thanks > > Peeter > > -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com

[SQL]

2000-12-11 Thread Peeter Smitt
Hi   Is it somehow possible to join tables from multiple databases into one query?   Thanks   Peeter    

Re: [SQL] FOREIGN KEY errors.

2000-12-11 Thread Joseph Shraibman
Script to reproduce the problem. It drops the tables at the end of the script. Stephan Szabo wrote: > > There was a bug (which should be fixed for 7.1) that got the > arguments wrong for the alter time check of the existing data. > I think I should be able to get a patch together to fix it once

Re: [SQL] Query optimisation

2000-12-11 Thread Richard Huxton
From: "Michel Vrand" <[EMAIL PROTECTED]> > $conditions may be > > 1/ ...AND groupes.nom = '$something' AND > or > 2/ ...AND groupes.nom ~* '$something' AND > > In the first case, the query is reasonnably fast (0.30 s for 4 items on > 15000) > In the second case, the query becomes very sl

[SQL] Where Can I find JDBC driver.

2000-12-11 Thread Mateusz Mazur
Hello. I wonder where I can find JDBC driver for Postgresql. I think it should be class (sorry I am newbie). I would be very greatfull for quick response. Mateusz.

[SQL] Query optimisation

2000-12-11 Thread Michel Vrand
Hi! I first apologize for my poor english. We are working with linux-apache-postgresql-php3. One among our queries is structured as follow : $result = pg_exec ($conn, "SELECT produits.id_produit, produits.id_proprio, articles.categ, groupes.nom, produits.pvttc_prod, articles.titre, articles.type