Re: Selecting a constant question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Selecting a constant question
Date
Msg-id 26701.1181601286@sss.pgh.pa.us
Whole thread Raw
In response to Re: Selecting a constant question  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Selecting a constant question  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
> Giving me the information about the data type will be enough.  As an
> example, in this case we have varchar data.  If the server should be so
> kind as to report varchar(1) for '1' or varchar(3) for '123' then I
> would not have any difficulty binding the data to a grid.

This seems merest fantasy.  Reflect on multibyte character sets for a
bit --- even if it's known that the column is varchar(3) there is no
guarantee that the value will fit in 3 bytes.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Selecting a constant question
Next
From: "Dann Corbit"
Date:
Subject: Re: Selecting a constant question