pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedOperators and Functions
4+ messages / 3 participants
[nested] [flat]
* Operators and Functions
@ 2000-12-10 21:12 Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 4+ messages in thread
From: Peter Eisentraut @ 2000-12-10 21:12 UTC (permalink / raw)
To: pgsql-docs
I was starting to update the chapter on operators in the User's Guide but
when I arrived at the LIKE operator/function it occurred to me that the
division between functions and operators is quite unnatural.
ISTM that someone reading the User's Guide is primarily interested in
solving a problem, like "How do I mangle my text strings?", and doesn't
necessarily care whether the answer is implemented as an operator or a
function.
I'd envision merging the information into one chapter with the following
outline:
Functions and Operators
Comparison
(>, <, <>, etc.)
Arithmetic and Trigonometry
(+, -, abs, sin, ...)
Character string manipulation
(||, trim, repeat, length, etc.)
Pattern matching
(LIKE, ~)
Formatting
(to_char, ...)
Date/Time
Geometry
Network Address Type Functions and Operators
Special Conditionals
(COALESCE, NULLIF, CASE)
Miscellaneous
(CURRENT_USER, SESSION_USER)
Aggregate Functions
Lexical precedence would move into the "SQL Syntax" chapter.
Comments?
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Operators and Functions
@ 2000-12-10 23:01 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2000-12-10 23:01 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> ... the division between functions and operators is quite unnatural.
Agreed --- especially seeing as how every operator has an underlying
function.
> I'd envision merging the information into one chapter with the following
> outline:
Seems reasonable to me.
BTW, this may be more work than you want to do right now, but ISTM that
the "example" columns in those tables would be lots more useful if the
result of the example were shown too. I did that for the network
functions already, but haven't got round to working on the rest.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Operators and Functions
@ 2000-12-11 18:45 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 4+ messages in thread
From: Thomas Lockhart @ 2000-12-11 18:45 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
> I'd envision merging the information into one chapter with the following
> outline:
All good. Btw, what would you suggest wrt listing you as (an? the?) docs
editor for this release?
- Thomas
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Operators and Functions
@ 2000-12-14 20:25 Peter Eisentraut <peter_e@gmx.net>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2000-12-14 20:25 UTC (permalink / raw)
To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: pgsql-docs
Thomas Lockhart writes:
> All good. Btw, what would you suggest wrt listing you as (an? the?) docs
> editor for this release?
I think an <authorgroup>PostgreSQL Global Development Group</> plus a few
acknowledgements where other sources have been used is enough for our
purposes. We generally don't identify the release engineer separately
either.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-12-14 20:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-10 21:12 Operators and Functions Peter Eisentraut <peter_e@gmx.net>
2000-12-10 23:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-12-11 18:45 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-12-14 20:25 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox