Re: [GENERAL] Bottom Posting

2008-05-27 Thread Andy Anderson
> > What do you mean whan you say "Don't top post??? > > http://en.wikipedia.org/wiki/Posting_style On May 27, 2008, at 7:41 PM, Gregory Williamson wrote: In-line comments are more readable, especially for longish emails. The PosgreSQL mail lists all prefer this method. Some related lists (t

Re: [GENERAL] IN query operator and NULL values

2008-05-16 Thread Andy Anderson
The non-compliance fix is described here: http://www.postgresql.org/docs/8.3/interactive/functions- comparison.html says: To check whether a value is or is not null, use the constructs expression IS NULL expression IS NOT NULL or the equivalent, but nonstandard, constructs Note: If th

Re: [GENERAL] PG -v- MySQL

2008-05-14 Thread Andy Anderson
On May 13, 2008, at 11:42 AM, Merlin Moncure wrote: Here are some other things we have v. mysql: *) Much better shell I tend to agree based on my limited experience. However, being a GUI-oriented person I haven't noticed management tools comparable to phpMyAdmin (for web) and CocoaMySQL

Re: [GENERAL] rounding problems

2008-05-14 Thread Andy Anderson
Sam Mason wrote: If you mean FoxPro, I think this is another case of MS screwing up. On May 14, 2008, at 4:08 PM, Justin wrote: Foxpro normally did not suffer form other MS screw ups. That's because MS bought it from a third-party developer. (And so, of course, they couldn't allow that to s

Re: [GENERAL] rounding problems

2008-05-14 Thread Andy Anderson
On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote: My problem is we calculate resistance of parts in a Foxpro app that we want to move because we want to bring all the custom apps into one framework and single database. Take this calculation (0.05/3* 1.0025) which is used to calcul

Re: [GENERAL] rounding problems

2008-05-12 Thread Andy Anderson
On May 12, 2008, at 6:37 PM, Justin wrote: lets take this select (9/10), (9/10)::numeric, (9::numeric/10::numeric), (9./10), (9*.1) With the given select statement i expected the results all to be same, especially sense it cast 4 of the 5 to numeric either with explicit cast or by conta

Re: [GENERAL] rounding problems

2008-05-12 Thread Andy Anderson
Andy Anderson wrote: Can you be more explicit about the rounding that's wrong in Excel? Are you talking about the n5 round-up to n+1 that Excel uses vs. n5 round-to-even n (sometimes called Banker's Rounding)? On May 12, 2008, at 2:38 PM, Justin wrote: Yes i'

Re: [GENERAL] rounding problems

2008-05-12 Thread Andy Anderson
Can you be more explicit about the rounding that's wrong in Excel? Are you talking about the n5 round-up to n+1 that Excel uses vs. n5 round-to-even n (sometimes called Banker's Rounding)? -- Andy On May 12, 2008, at 1:48 PM, Justin wrote: I have very annoying problem that i would l

Re: [GENERAL] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server:

2008-05-12 Thread Andy Anderson
Abdus Samad Ansari <[EMAIL PROTECTED]> writes: I have setup PHP/Postgres and is running fine upto document root i.e. /var/www/html, but when i am calling it through a cgi-bin php file it is giving log error as : [error] [client 127.0.0.1] PHP Warning: pg_connect(): Unable to connect to Pos

Re: [GENERAL] bytea and character encoding when inserting escaped literals

2008-05-05 Thread Andy Anderson
I'm thinking that the answer is in the literal interpretation of the error message, i.e. it doesn't like the specific byte 0x00, i.e. the null byte. According to the docs (4.1.2.1. String Constants): "The character with the code zero cannot be in a string constant." The reason may be that th

Re: [GENERAL] Quoting "

2008-04-30 Thread Andy Anderson
On Wed, Apr 30, 2008 at 9:10 AM, Andy Anderson <[EMAIL PROTECTED]> wrote: In a test I just did, the sequence \" (backslash double-quote) is interpreted as just a " inside of the E'...' string constant expression. This is great, since PHP's addslashes() sticks

Re: [GENERAL] Quoting "

2008-04-30 Thread Andy Anderson
Ah, slight ambiguity here. Perhaps this might best say "Any other character following a backslash is taken literally, and the backslash is removed." Thanks, -- Andy On Apr 30, 2008, at 10:28 AM, Tom Lane wrote: Andy Anderson <[EMAIL PROTECTED]> writes: In a test I just d

[GENERAL] Quoting "

2008-04-30 Thread Andy Anderson
In a test I just did, the sequence \" (backslash double-quote) is interpreted as just a " inside of the E'...' string constant expression. This is great, since PHP's addslashes() sticks them in along with the other stuff I really need to quote like ' and \. But I see that \" isn't documente

[GENERAL] Character Data Type 'Name'

2008-04-29 Thread Andy Anderson
I'm creating my own table of metadata about other tables in my database. As such, one column will be the names of those other tables, and the maximum length of the data in this column would be the allowed length of an identifier. So one possible data type for this column would be 'varchar(N