Re: Default 1 == Default 16777216?

2001-12-11 Thread Dave Burgess
Obvious stupid question: What happens when you specify the value as 16777216? Since you are running on a SPARC, I'm sure you will end up with the correct value (1) in the space. If that works, there is definitely an endism problem. Dave Philip Molter wrote: Description: When I do this:

Re: Default 1 == Default 16777216 ?

2001-12-10 Thread Dave Burgess
You wouldn't happen to be crossing an architecture boundary, would you? Say from a Macintosh client to a PC server, or a PC client to a Sun Server? 16777216 Decimal = 100 Hex which would make perfect sense if there was an 'endism' problem. Philip Molter wrote: I have a 3.23.45 database

I need some help translating a PostgreSQL Query to MySQL

2001-12-06 Thread Dave Burgess
I was wondering if anyone could help me converting some PostgreSQL queries with sub-queries into a similar form usable (hopefully) by both, or at least into a form that I can use in place of the PostgreSQL ones. I'm going to post them - I hope no one minds. If this is the wrong mailing list for