From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | What is ##? |
Date: | 1998-02-02 02:24:04 |
Message-ID: | Pine.BSF.3.96.980201222221.12562k-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
geometry regression test:
QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
FROM LSEG_TBL l, POINT_TBL p;
thirty|f1 |s |closest
------+----------+-----------------------------+--------------------------------
----
|(0,0) |[(1,2),(3,4)] |(1,2)
|(-10,0) |[(1,2),(3,4)] |(1,2)
|(-3,4) |[(1,2),(3,4)] |(1,2)
|(5.1,34.5)|[(1,2),(3,4)] |(3,4)
|(-5,-12) |[(1,2),(3,4)] |(1,2)
|(10,10) |[(1,2),(3,4)] |(3,4)
|(0,0) |[(0,0),(6,6)] |(-0,0)
This last line, in the current results, provides a value of (0,0) for
closest, but I can't find what ## means in order to determine if this is
as expected...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-02-02 02:40:12 | Re: [HACKERS] Variable block size... |
Previous Message | The Hermit Hacker | 1998-02-02 02:17:31 | float8 regression test |