[GENERAL] Unique cosntraint based on contents of a field?

, Warren Bell -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Bad Timestamp Format at 23 in ...

ses the same exact database on the Apple I get a "Bad > Timestamp Format at 23 in 2008-09-16 18:41:00.479" error. I am guessing > that it has something to do with how Java creates Dates on Unix verses > Windows. Is this a JDBC issue or is there something I need to do in > Postg

[GENERAL] Bad Timestamp Format at 23 in ...

t;Bad Timestamp Format at 23 in 2008-09-16 18:41:00.479" error. I am guessing that it has something to do with how Java creates Dates on Unix verses Windows. Is this a JDBC issue or is there something I need to do in Postgres to make this work? -- Thanks, Warren Bell 909-645-8864 [EMAIL PROTECTED]

[GENERAL] Problem escaping, nonstandard use of \\ in a string literal

l-8.3-603.jdbc3.jar as the driver. I see that you can escape by doing E'Joe\'s', but how do I get this to work without going through my code and shouldn't this be done by the driver. How do I get this all to work? -- Thanks, Warren Bell 909-645-8864 [EMAIL PROTECTED] -

Re: [GENERAL] CAST(integer_field AS character) truncates trailing zeros

I guess it would help if I cast to the correct type. I was doing cast( cast( 1000 as integer ) as char ) instead of character varying, char(n) or text. Thanks, Warren Warren Bell wrote: I am trying to cast an int to a character. The int is the number 1000 it gets cast down to "1&quo

[GENERAL] CAST(integer_field AS character) truncates trailing zeros

I am trying to cast an int to a character. The int is the number 1000 it gets cast down to "1" and not "1000". How do I cast from int to character without loosing the trailing zeros? -- Thanks, Warren Bell -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

[GENERAL] PDF Documentation?

Is there a pdf version of the documentation ? I find HTML version much harder to read than a printed copy. Thanks, Warren Bell ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Speed problems

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe > Sent: Wednesday, September 14, 2005 8:24 AM > To: Warren Bell > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Speed problems > > > On Tue, 20

Re: [GENERAL] Speed problems

>On Tue, 2005-09-13 at 13:20, Warren Bell wrote: >> I am having problems with performance. I think this is a simple question and >> I am in the right place, if not, please redirect me. >> >> I have a table with 36 fields that slows down quite a bit after some light >&

[GENERAL] Speed problems

will not speed it up. I drop the table and recreate it and insert one record and it speeds right back up takeing only 100 ms to do the query. I am fairly new to Postgres. What do I need to do to keep this table from slowing down? Thanks, Warren Bell ---(end of