From: | <jeffdavey(at)submersion(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Using char fields with 7.1.3 driver] |
Date: | 2001-09-07 02:37:13 |
Message-ID: | 40619.208.38.32.236.999830233.squirrel@webmail.submersion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Well, that's how it works in the postgres documentation... I could have
sworn that I've never encountered this in other databases.. Must have a bad
memory.
Guess I'll just trim everything.
-Jeff
> Hmm.. ok.
>
> Just I usually prefer using fixed field lengths as queries tend to be
> significantly faster. Also, you can use them in indexes.
>
> I find it strange that that would be the case...
>
> And it leads me to wonder how you would represent an ending "space" in
> a field,
>
>
> for example
> insert into names values(1,'This is a space ');
>
> for perhaps some sort of formatting or something otherwise.
>
> I'll try and find something in the postgres documentation to disable
> this then I guess.
>
>
> -Jeff
>
> -------- Original Message --------
> Subject: Re: [JDBC] Using char fields with 7.1.3 driver
> From: "David Wall" <d(dot)wall(at)computer(dot)org>
> To: <pgsql-jdbc(at)postgresql(dot)org>
>
> I'm not a JDBC expert, but this is pretty much the way I'd expect it to
> work. If you a have fixed length field, then the field should return
> that many characters. The varchar implies it's variable length, so
> trailing spaces would then not be included.
>
> David
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 3: if posting/reading through
> Usenet, please send an appropriate subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-09-07 02:43:47 | Re: [Fwd: Re: Using char fields with 7.1.3 driver] |
Previous Message | jeffdavey | 2001-09-07 02:27:56 | [Fwd: Re: Using char fields with 7.1.3 driver] |