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
> 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
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
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
Hi All ,
SELECT DISTINCT h_name FROM haszon;
+---+
| h_name|
+---+
| CITROEN |
| DAEWOO-FSO|
| DAEWOO-LUBLIN |
| FIAT |
| FORD |
| GAZ |
| HYUNDAI |
| KIA |
| MAZDA |
| MERCEDES BENZ |
| MITSUBISHI|