[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

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

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] -- Sent

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

-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] -- Sent via pgsql-general

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

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] -- Thanks, Warren Bell 909-645-8864

[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.org) To make changes

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

[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, 2005-09-13 at 21:01, Warren Bell wrote

[GENERAL] Speed problems

and this 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

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 use. There are only 5 clients connected