Re: [HACKERS] 7.4 Wishlist

2002-11-30 Thread Gabor Csuri
Hi All, here is my wishlist /very short/ : * Oracle syntax support in OUTER JOIN Thanks, Gabor > Hans-Jürgen Schönig wrote: > > What I'd like to have in future versions of PostgreSQL: > > > > - PL/Sh should be in contrib. i know that the core team has decided > > not to put it in the core

Re: [HACKERS] Index not used ! Why?

2001-10-25 Thread Gabor Csuri
> Hello! > It needs some help by the command > VACUUM [VERBOSE] ANALYZE table; > to choose the ideal query strategy. How can I choose better query strategy than ...WHERE key_field = x; ? Regards, Gabor. ---(end of broadcast)--- TIP 5: Have you c

[HACKERS] Index not used ! Why?

2001-10-25 Thread Gabor Csuri
Hi All, my database server has very high load in this morning. I've found the problem. One of my index was not used so far! it's interesting: addb=> \d banners Table "banners" Attribute | Type | Modifier

[HACKERS] Re: I don't understand...

2001-05-22 Thread Gabor Csuri
Hi All again, after I deleted the "null row" from carname: SELECT DISTINCT h_name FROM haszon WHERE h_name NOT IN (SELECT cn_name FROM carname) +---+ | h_name| +---+ | DAEWOO-FSO| | DAEWOO-LUBLIN | | GAZ | | TATA | +---+ Query O

[HACKERS] I don't understand...

2001-05-22 Thread Gabor Csuri
Hi All , SELECT DISTINCT h_name FROM haszon; +---+ | h_name| +---+ | CITROEN | | DAEWOO-FSO| | DAEWOO-LUBLIN | | FIAT | | FORD | | GAZ | | HYUNDAI | | KIA | | MAZDA | | MERCEDES BENZ | | MITSUBISHI|