Commit31845dd

committed

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.

1 parent0b88b63 commit31845ddCopy full SHA for 31845dd

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group`
`8`	`8`	`* Portions Copyright (c) 1994, Regents of the University of California`
`9`	`9`	`*`
`10`		`- * $Id: pg_proc.h,v 1.292 2003/04/08 23:20:03 tgl Exp $`
	`10`	`+ * $Id: pg_proc.h,v 1.293 2003/04/17 04:50:20 tgl Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`* The script catalog/genbki.sh reads this file and generates .bki`
`@@ -1698,7 +1698,7 @@ DESCR("less-equal-greater");`
`1698`	`1698`	`DATA(insertOID=1359 (timestamptzPGNSPPGUID12fftfi21184"1082 1266"datetimetz_timestamptz-_null_ ));`
`1699`	`1699`	`DESCR("convert date and time with time zone to timestamp with time zone");`
`1700`	`1700`
`1701`		`-DATA(insertOID=1364 (timePGNSPPGUID14fftfi11083"702""selecttime(cast($1 as timestamp without time zone))"-_null_ ));`
	`1701`	`+DATA(insertOID=1364 (timePGNSPPGUID14fftfs11083"702""selectcast(cast($1 as timestamp without time zone) as time)"-_null_ ));`
`1702`	`1702`	`DESCR("convert abstime to time");`
`1703`	`1703`
`1704`	`1704`	`DATA(insertOID=1367 (character_lengthPGNSPPGUID12fftfi123"1042"bpcharlen-_null_ ));`

Comments

(0)