Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-23 Thread Neil Conway
Tom Lane wrote: I'm not set on it --- fix it as you suggested. Attached is a patch that implements this. I'm not especially happy about the implementation: defining _two_ local macros (that both doubly-evaluate one of their arguments) is pretty ugly, but I didn't see a cleaner alternative --

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-23 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Any thoughts on this, Tom? If you're planning on doing the rewrite you > described, that's fine; alternatively I'm happy to implement the fix > that I described above. I'm not set on it --- fix it as you suggested. regards, tom l

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-23 Thread Neil Conway
Neil Conway wrote: I think we _can_ do it that way, it's just a question of whether that is the best approach. I think the solution I outlined before would work fine: pass the length of the working buffer to ParseDateTime(), and reject the input only if the parsing process actually requires mor

Re: [BUGS] BUG #1677: Bug in select with Union

2005-05-23 Thread Tom Lane
"Julien Vallet" <[EMAIL PROTECTED]> writes: > The result is "ERROR: UNION types text and bigint cannot be matched" This is the identical issue reported here: http://archives.postgresql.org/pgsql-bugs/2005-02/msg8.php See also this thread: http://archives.postgresql.org/pgsql-general/2005-02/m

[BUGS] BUG #1677: Bug in select with Union

2005-05-23 Thread Julien Vallet
The following bug has been logged online: Bug reference: 1677 Logged by: Julien Vallet Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 & 8.0.3 Operating system: Windows XP Description:Bug in select with Union Details: I think there is a problem with the sel

Re: [BUGS] initdb fails on ultra2 sparc64, freebsd 5.4

2005-05-23 Thread Andrew - Supernews
On 2005-05-21, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: >> On 2005-05-21, Tom Lane <[EMAIL PROTECTED]> wrote: >>> initdb does not use libpq ... it might link to it, > >> Linking to it is enough to bring in libc_r, and pick up libc_r's versions >> of at le