Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Josh Berkus
Guys, > > Well, yes, actually. Where in the documentation is a type conversion > > expression defined? Do we use NEW and OLD? Or the name of the column? > > Or something else? > > I think the ALTER TABLE page is in dire need of a "See also" section, at > least. And a reference to where is d

Re: [DOCS] Version information in docs

2005-03-27 Thread Jim C. Nasby
On Sun, Mar 27, 2005 at 08:54:22PM -0500, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > ISTM it would be very useful if the docs specified what version a > > feature that would break in older versions was implemented in. The > > example that comes to mind is argument names in CRE

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Alvaro Herrera
On Sun, Mar 27, 2005 at 05:11:43PM -0800, Josh Berkus wrote: > > ALTER [ COLUMN ] column TYPE type [ USING expression ] > > > > Surely you're not expecting it to repeat the complete syntax for > > . > > Well, yes, actually. Where in the documentation is a type conversion > expression define

Re: [DOCS] Version information in docs

2005-03-27 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > ISTM it would be very useful if the docs specified what version a > feature that would break in older versions was implemented in. The > example that comes to mind is argument names in CREATE FUNCTION, which > was added in 8.0. The 8.0 docs (http://lnk.n

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Josh Berkus
Tom, > ALTER [ COLUMN ] column TYPE type [ USING expression ] > > Surely you're not expecting it to repeat the complete syntax for > . Well, yes, actually. Where in the documentation is a type conversion expression defined? Do we use NEW and OLD? Or the name of the column? Or somethi

Re: [PATCHES] [DOCS] Approximate count(*)

2005-03-27 Thread Jim C. Nasby
Josh, David- Do you think it's worth adding a function that would do the select for you? IE: tuplecount('schema', 'tablename')? On Thu, Mar 24, 2005 at 07:19:00PM -0800, Josh Berkus wrote: > David, > > If Jim and I finish our work for 8.1, then you'll be able to do: > > SELECT approx_records FR

[DOCS] Version information in docs

2005-03-27 Thread Jim C. Nasby
ISTM it would be very useful if the docs specified what version a feature that would break in older versions was implemented in. The example that comes to mind is argument names in CREATE FUNCTION, which was added in 8.0. The 8.0 docs (http://lnk.nu/postgresql.org/1y3.html) mention the ability to n