Title:
Hi Rahul,Have you tried to quote each table name and
column name by " , and constant by ' ? In your case, try delete from "reporttable" where ( "srvServerid"
= 'serverid') and( "rptreportid" not in(select "rptreportid" from "reporttable"where ( "srvserverid"
= 'serverid' order
On Tue, 31 Jul 2001 [EMAIL PROTECTED] wrote:
> Rahul Gade ([EMAIL PROTECTED]) reports a bug with a severity of 1
Umm, 1? IIRC, order by in subqueries isn't even standard SQL, however
this should be taken care of in current sources so that you can use
order by ... limit in subqueries which soun
Anthony Wood ([EMAIL PROTECTED]) writes:
> [ SELECT DISTINCT ON in a subquery-in-FROM misbehaves ]
Here's the patch against 7.1.2 to fix this problem. This also fixes a
related problem noted a few days ago, that outer WHERE clauses shouldn't
be pushed down into a sub-select that has a LIMIT clau
Christian Villa Real Lopes ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
ERROR: parser: parse error at or near "execute"
Long Description
I created a function to drop a table if it exists. On pgsql-7.0.3 this function
retur
On Tue, 31 Jul 2001 [EMAIL PROTECTED] wrote:
> Christian Villa Real Lopes ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> ERROR: parser: parse error at or near "execute"
>
> Long Description I created a function to d
Hello!
Here's now to reproduce my bug:
* Start with Postgres 7.1.2
(specifically: PostgreSQL 7.1 on i386--freebsd4.3, compiled by GCC 2.95.3
)
* Install earthdistance operator from the contrib directory.
* try this:
cascade=> select null <@> '1,1'::point;
## The result I get:
pqReadData() -- b
Mark Stosberg <[EMAIL PROTECTED]> writes:
> * Install earthdistance operator from the contrib directory.
> * try this:
> cascade=> select null <@> '1,1'::point;
> ## The result I get:
> pqReadData() -- backend closed the channel unexpectedly.
Probably the earthdistance functions are not NULL-saf
I'll give it a shot and post the patch or let you know I'm stuck. :) Thanks!
-mark
Tom Lane wrote:
>
> Mark Stosberg <[EMAIL PROTECTED]> writes:
> > * Install earthdistance operator from the contrib directory.
> > * try this:
> > cascade=> select null <@> '1,1'::point;
>
> > ## The result
Rahul Gade ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
'order by' and 'desc' not working in subquery using 'not in'
Long Description
Hello,
I am facing two big problems,they may not be really big but in my case these are b
