Re: [GENERAL] SELECT statement with sub-queries

2017-05-28 Thread ml
On 28.05.2017 20:19, m...@ft-c.de wrote: Hallo, SELECT * FROM products WHERE exists (SELECT categories.cat FROM categories WHERE categories.serial==products.category); categories.serial = products.category); -- one equal sign or SELECT * FROM products WHERE category IN

Re: [GENERAL] SELECT statement with sub-queries

2017-05-28 Thread ml
Hallo, SELECT * FROM products WHERE exists (SELECT categories.cat FROM categories WHERE categories.serial==products.category); or SELECT * FROM products WHERE category IN (SELECT categories.cat FROM categories); On 28.05.2017 19:03, Michelle Konzack wrote: Hello *, I try to get

[GENERAL] tsearch2 memory problem

2009-05-06 Thread ml
Hi! I realized that loading a dictionary with ~16 words consumes additional ~40 MB of memory for each connection. It obviously doesn't use a shared memory. Is it possible to decrease the memory consumption? I found this thread http://www.mail-archive.com/pgsql-general@postgresql.org/msg116924

[GENERAL] Re: [HACKERS] Re: pg_dump with BLOBS & V7.0.2 UPDATED

2000-07-19 Thread Pavel Janík ml.
From: [EMAIL PROTECTED] (Pavel Janík ml.) Date: Wed, 19 Jul 2000 11:11:05 +0200 Hi, > this patch applied, just untar the newest snapshot to src/bin/pg_dump > and you can continue with normal installation: configure && make && > make install. hmm. PG_V

[GENERAL] Re: pg_dump with BLOBS & V7.0.2 UPDATED

2000-07-19 Thread Pavel Janík ml.
al installation: configure && make && make install. Thank you for good work. -- Pavel Janík ml. [EMAIL PROTECTED] diff -uN pg_dump_141.orig/Makefile pg_dump_141/Makefile --- pg_dump_141.orig/Makefile Wed Jul 19 10:53:31 2000 +++ pg_dump_141/Makefile Thu Jan