From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
---|---|
To: | pierre(at)desertmoon(dot)com |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] MINUS and slow 'not in' |
Date: | 1998-11-24 15:32:59 |
Message-ID: | l03110704b28081e9b1e2@[147.233.159.109] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
At 17:31 +0200 on 24/11/98, pierre(at)desertmoon(dot)com wrote:
>
> Yeah I've got 6.4. I tried:
>
> set query_limit to 2000;
>
> and got:
>
> ERROR: parser: parse error at or near "2000"
>
> Ideas?
Well, I don't have 6.4 as yet. However, reading the manpage, I surmise that
the value passed is a string value (To support "SET QUERY_LIMIT TO
'unlimited'"). Thus, try quoting the 2000...
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Auer | 1998-11-24 15:49:43 | pg_dump - segfault with -z option |
Previous Message | pierre | 1998-11-24 15:31:01 | Re: [SQL] MINUS and slow 'not in' |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-11-24 15:50:11 | Re: [HACKERS] Re: [SQL] cursor and update + view |
Previous Message | pierre | 1998-11-24 15:31:01 | Re: [SQL] MINUS and slow 'not in' |