Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Peter Eisentraut
Adriaan van Os wrote: > Besides, the question is absurd. I stumble over a stone on the road, > report it and then you ask "is there an actual use case where this is > a problem". Why else do I report it ? What you probably wanted to ask > is: "Apart from the missing warning along the road, couldn't

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> Aside from the apparent discrepancy between the documentation and the >> actual behavior, is there an actual use case where this is a problem? > No, I don't think so, and I am reluctant to adjust the documentation to > say "or

Re: [BUGS] Troubles in Initializing Postgres Database 8.2

2007-01-21 Thread Magnus Hagander
Maarten van der Heijden wrote: > I’m having trouble initialzing the PostGres Database 8.2 on Windows Xp > Embedded. Installation using the windows installer is going fine until > the initialization process is started. See below for the log. Installing > postgres without initializing the database cl

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Bruce Momjian
Peter Eisentraut wrote: > Adriaan van Os wrote: > > >> However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a > > >> result type. > > > > > > Yea, they are internally treated as very similar types. > > > > But "internally treated as very similar" is still not "same as > > argument type".

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Peter Eisentraut
Adriaan van Os wrote: > >> However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a > >> result type. > > > > Yea, they are internally treated as very similar types. > > But "internally treated as very similar" is still not "same as > argument type". Computing requires exactness. Aside fro

Re: [BUGS] BUG #2908: ISO8601 Date / Time Format Incompatibility

2007-01-21 Thread Peter Eisentraut
David Lloyd wrote: > According to the ISO standard, 8601: The date/time input format in PostgreSQL is determined by the SQL standard, not ISO 8601. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if po