| 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: | Whole Thread | Raw Message | 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 |