Re: [HACKERS] CREATE CAST too strict?

2008-08-23 Thread Peter Eisentraut
On Friday 22 August 2008 22:25:08 Bruce Momjian wrote: Peter, have you completed this yet? yes --- Peter Eisentraut wrote: Am Mittwoch, 9. Juli 2008 schrieb Peter Eisentraut: I propose that we relax these two

Re: [HACKERS] CREATE CAST too strict?

2008-08-22 Thread Bruce Momjian
Peter, have you completed this yet? --- Peter Eisentraut wrote: Am Mittwoch, 9. Juli 2008 schrieb Peter Eisentraut: I propose that we relax these two checks to test for binary-coercibility instead, which is effectively

Re: [HACKERS] CREATE CAST too strict?

2008-07-10 Thread Peter Eisentraut
Am Mittwoch, 9. Juli 2008 schrieb Peter Eisentraut: I propose that we relax these two checks to test for binary-coercibility instead, which is effectively what is expected and required here anyway. Here is the corresponding patch. diff -ur ../cvs-pgsql/doc/src/sgml/ref/create_cast.sgml

Re: [HACKERS] CREATE CAST too strict?

2008-07-10 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Am Mittwoch, 9. Juli 2008 schrieb Peter Eisentraut: I propose that we relax these two checks to test for binary-coercibility instead, which is effectively what is expected and required here anyway. Here is the corresponding patch. Looks good, but

[HACKERS] CREATE CAST too strict?

2008-07-09 Thread Peter Eisentraut
I noticed that some of the entries in pg_cast are shaped in a way that CREATE CAST wouldn't let pass. For example, the cast from cidr to varchar is effectively defined as CREATE CAST (cidr AS varchar) WITH FUNCTION text(inet) AS ASSIGNMENT; but CREATE CAST wouldn't allow this because the