diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-17 04:50:20 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-17 04:50:20 +0000 |
| commit | 31845dd363d0af874cd34168302b74ed4a381890 (patch) | |
| tree | 2ad96dc831fb16645271c780dd1d9bb276e304b8 /src | |
| parent | 0b88b637090b6030e1dc2c294e69506ae5d390fc (diff) | |
| download | postgresql-31845dd363d0af874cd34168302b74ed4a381890.tar.gz postgresql-31845dd363d0af874cd34168302b74ed4a381890.zip | |
Fix abstime-to-time cast function, which has had broken implementation
since 7.2, per bug #947. Turns out it had wrong volatility label, too.
Can't force initdb in 7.3 branch, but fix anyway for future installs.
Diffstat (limited to 'src')
| -rw-r--r-- | src/include/catalog/pg_proc.h | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 1ac9dd22b01..ee20811165b 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.292 2003/04/08 23:20:03 tgl Exp $ + * $Id: pg_proc.h,v 1.293 2003/04/17 04:50:20 tgl Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -1698,7 +1698,7 @@ DESCR("less-equal-greater"); DATA(insert OID = 1359 ( timestamptz PGNSP PGUID 12 f f t f i 2 1184 "1082 1266" datetimetz_timestamptz - _null_ )); DESCR("convert date and time with time zone to timestamp with time zone"); -DATA(insert OID = 1364 ( time PGNSP PGUID 14 f f t f i 1 1083 "702" "select time(cast($1 as timestamp without time zone))" - _null_ )); +DATA(insert OID = 1364 ( time PGNSP PGUID 14 f f t f s 1 1083 "702" "select cast(cast($1 as timestamp without time zone) as time)" - _null_ )); DESCR("convert abstime to time"); DATA(insert OID = 1367 ( character_length PGNSP PGUID 12 f f t f i 1 23 "1042" bpcharlen - _null_ )); |