timestamp() functions still documented

Поиск
Список
Период
Сортировка
Искать

timestamp() functions still documented

От:
Oliver Elphick <olly@lfix.co.uk>
Дата:
Вложения:
The functions timestamp(date) and timestamp(date, time) are still
documented, but cannot be used because the parser interprets
timestamp(xx) as timestamp with precision.

So the documentation of those functions ought to be removed, because it
confuses users (the same applies to the documentation of 7.2.1):

Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.96
diff -c -r1.96 func.sgml
*** doc/src/sgml/func.sgml	2002/04/26 01:24:08	1.96
--- doc/src/sgml/func.sgml	2002/05/03 08:40:01
***************
*** 2730,2750 ****
  	Wed Feb 21 17:01:13.000126 2001 EST
         
  
-        
- 	timestamp(date)
- 	timestamp
- 	date to timestamp
- 	timestamp(date '2000-12-25')
- 	2000-12-25 00:00:00
-        
- 
-        
- 	timestamp(date,
time)
- 	timestamp
- 	date and time to
timestamp
- 	timestamp(date '1998-02-24',time
'23:07')
- 	1998-02-24 23:07:00
-        
        
       
      
--- 2730,2735 ----


There are seven timestamp() functions in pg_proc and I don't think any
of them can be used; should they not be removed or renamed?

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Rejoice with them that do rejoice, and weep with them 
      that weep."            Romans 12:15 

Re: timestamp() functions still documented

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Oliver Elphick  writes:
> There are seven timestamp() functions in pg_proc and I don't think any
> of them can be used; should they not be removed or renamed?

Not unless you want to break the cast operations that use these
functions.  OID 2025 isn't a cast and perhaps should be renamed,
but the rest are correct as-is.

I do agree that something needs to be done with the documentation...

			regards, tom lane

Re: timestamp() functions still documented

От:
Thomas Lockhart <lockhart@fourpalms.org>
Дата:
...
> There are seven timestamp() functions in pg_proc and I don't think any
> of them can be used; should they not be removed or renamed?

They are used internally for type coersion. The problem is only at the
parser level, where SQL9x mandates a conflicting syntax.

                    - Thomas

Re: timestamp() functions still documented

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

Patch applied.

---------------------------------------------------------------------------

Oliver Elphick wrote:
-- Start of PGP signed section.
> The functions timestamp(date) and timestamp(date, time) are still
> documented, but cannot be used because the parser interprets
> timestamp(xx) as timestamp with precision.
> 
> So the documentation of those functions ought to be removed, because it
> confuses users (the same applies to the documentation of 7.2.1):
> 
> Index: doc/src/sgml/func.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v
> retrieving revision 1.96
> diff -c -r1.96 func.sgml
> *** doc/src/sgml/func.sgml	2002/04/26 01:24:08	1.96
> --- doc/src/sgml/func.sgml	2002/05/03 08:40:01
> ***************
> *** 2730,2750 ****
>   	Wed Feb 21 17:01:13.000126 2001 EST
>          
>   
> -        
> - 	timestamp(date)
> - 	timestamp
> - 	date to timestamp
> - 	timestamp(date '2000-12-25')
> - 	2000-12-25 00:00:00
> -        
> - 
> -        
> - 	timestamp(date,
> time)
> - 	timestamp
> - 	date and time to
> timestamp
> - 	timestamp(date '1998-02-24',time
> '23:07')
> - 	1998-02-24 23:07:00
> -        
>         
>        
>       
> --- 2730,2735 ----
> 
> 
> There are seven timestamp() functions in pg_proc and I don't think any
> of them can be used; should they not be removed or renamed?
> 
> -- 
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
> 
>      "Rejoice with them that do rejoice, and weep with them 
>       that weep."            Romans 12:15 
-- End of PGP section.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
FAQ