| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brent Verner <brent(at)rcfile(dot)org> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Can't "EXTRACT" from a field? |
| Date: | 2001-11-22 17:50:09 |
| Message-ID: | 1615.1006451409@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Brent Verner <brent(at)rcfile(dot)org> writes:
> note: extract() is correctly not listed as a function, but it doesn't
> have any '\h' help available. Is this a TODO kind-of-thing? If
> it is I can try to add it sometime later today.
There is no mechanism for keeping track of help entries for functions,
only statements.
> note2: This documentation is incorrect as of last night's cvs.
> an example given in the docs is.
> SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40');
This example is fine. Try it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2001-11-22 17:57:32 | v7.2b3 packaged, but not announced beyond here yet ... |
| Previous Message | Brent Verner | 2001-11-22 17:22:15 | Re: Can't "EXTRACT" from a field? |