PostgreSQL + INTERSECT = problem

[Cyril Franko]

zdravim,

z vlastnej skusenosti mozem poradit pouzit nasledujucu konstrukciu

1. SELECT co INTO TEMP docasna FROM ....
2. SELECT daco FROM tab1 t, docasna d WHERE vhodna podmienka

takato konstrukcia vyrazne urychli spracovanie oproti zlozitemu jednemu
SELECTu s roznymi zlozitymi podmienkami.

docasna tabulka sa po ukonceni spracovania automaticky odstrani.

s pozdravom
Cyril Franko
fc282 na email.com


> >Mam zajivavy problem, u $subj, pokud zadam slozitejsi dotaz, (i na
> postgresove kozoli) backend spadne, je-li v nem INTERSECT, neco jako
> SELECT+"300 znaku podminek"+INTERSECT + libovolne maly select. a dostavam
> hlasku:
> >
> >pqReadData() -- backend closed the channel unexpectedly.
> >        This probably means the backend terminated abnormally
> >        before or while processing the request.
> >We have lost the connection to the backend, so further processing is
> impossible.Terminating.
>
>