Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Markus Schiltknecht
Hi, Tom Lane wrote: Well, you're probably fine with integers and text, but beyond that it gets a bit more dicey. I wouldn't want to assume that floats are compatible across any random pair of architectures, and in the more complex datatypes (such as arrays or geometric types) there might be som

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Tom Lane
Markus Schiltknecht <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think you'd be nuts to bet your data on the binary representations >> really being cross-platform compatible. > Can you elaborate on this? AFAICT the send/recv functions use network > byte ordering. What are the other problems

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Markus Schiltknecht
Hello Tom, Tom Lane wrote: I think you'd be nuts to bet your data on the binary representations really being cross-platform compatible. Can you elaborate on this? AFAICT the send/recv functions use network byte ordering. What are the other problems between different architectures? There mi

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > I think you'd be nuts to bet your data on the binary representations > really being cross-platform compatible. There might be some excuse for > doing this within a single architecture, but I can't get very excited > about it ... Well they're not very use

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Tom Lane
Markus Schiltknecht <[EMAIL PROTECTED]> writes: > Gregory Stark wrote: >> Perhaps if you're doing some form of replication between different >> architectures you might want to use binary representation for your transfers. >> Or if you're doing something in a PL language like compressing or bundling

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Markus Schiltknecht
Hi, Gregory Stark wrote: Perhaps if you're doing some form of replication between different architectures you might want to use binary representation for your transfers. Or if you're doing something in a PL language like compressing or bundling up multiple data in a container format or something

Re: [HACKERS] [COMMITTERS] pgsql: Fix up text concatenation so that it accepts all the reasonable

2007-09-17 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Log Message: > --- > Fix up text concatenation so that it accepts all the reasonable cases that > were accepted by prior Postgres releases. This takes care of the loose end > left by the preceding patch to downgrade implicit casts-to-text. To avo