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 (the

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

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

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

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

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

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

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'm taking about

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

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

[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 documented

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 did, the sequence

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 them in along with the other stuff

[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