| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: SQL99 doc update |
| Date: | 2002-07-01 04:25:15 |
| Message-ID: | 3D1FD9AB.FD483986@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
> > > This fixes 2 inaccuracies in the recently added SQL99 feature list docs.
> > > UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK,
> > > neither is.
> > I'm working on adding the IS DISTINCT FROM clause. I haven't looked to
> > see about UNIQUE. Remind me to readjust the docs when we get that
> > working.
> Where are these two new clauses used?
I haven't looked yet at UNIQUE. IS DISTINCT FROM takes two row
expressions and compares them; if every element compares equal (or if
both elements are NULL) then the two expressions are considered to be
"not distinct" and FALSE is returned. Otherwise the two expressions are
considered to be distinct.
- Thoas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-07-01 04:29:21 | Re: SQL99 doc update |
| Previous Message | Christopher Kings-Lynne | 2002-07-01 04:16:43 | Re: SQL99 doc update |