Bruce Momjian <[EMAIL PROTECTED]> writes:
> I found the cause. Equals for boxes compares only area, \do:
... which is in itself pretty bogus IMHO. There are a couple of the
geometric types for which '=' does not do what you'd really expect.
I've been wondering if we could get away with changing
Bruce Momjian wrote:
> Is there a way to do a SELECT DISTINCT on boxes:
>
> test=> create TABLE t3 (a box);
> CREATE TABLE
> test=> insert into t3 values ('(2,2),(1,1)');
> INSERT 17232 1
> test=> insert into t3 values ('(2,2),(1,1)');
> INSERT 17233
Is there a way to do a SELECT DISTINCT on boxes:
test=> create TABLE t3 (a box);
CREATE TABLE
test=> insert into t3 values ('(2,2),(1,1)');
INSERT 17232 1
test=> insert into t3 values ('(2,2),(1,1)');
INSERT 17233 1
test=> insert into t3 valu
The following bug has been logged online:
Bug reference: 1193
Logged by: Stefan Sassenberg
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:Some query sequences do not finish
Details:
Hello,
this happens on a databas
The following bug has been logged online:
Bug reference: 1192
Logged by: oliver dauben (adc hofheim)
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: any (tested w/ win NT, win XP, linux 2.4.x)
Description:JDBC driver: org.postgresql.jdbc
