"Decibel!" <[EMAIL PROTECTED]> writes:
> On Sep 3, 2007, at 7:26 AM, Gregory Stark wrote:
>> Also, incidentally do you have a good reason to use CHAR instead of varchar
>> or
>> text? char(64) will take 64 bytes (actually 68 bytes in 8.2) even if you
>> don't
>> store anything more in it. text o
On Sep 3, 2007, at 7:26 AM, Gregory Stark wrote:
Also, incidentally do you have a good reason to use CHAR instead of
varchar or
text? char(64) will take 64 bytes (actually 68 bytes in 8.2) even
if you don't
store anything more in it. text or varchar will take only as many
bytes as the
data
Rodrigo De León skrev:
> On 9/18/07, Philippe Lang <[EMAIL PROTECTED]> wrote:
>> ... into this:
>>
>>
>> serial dateL dateR
>>
>> 1 1 2
>> 1 4
>> 2 1 2
>> 3 1 3
>> 4 2 3
>> 5 3
>
> SELECT t1.serial, t1.DATE AS datel,