Re: [SQL] Speeding up schema changes

2007-09-19 Thread Gregory Stark
"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

Re: [SQL] Speeding up schema changes

2007-09-19 Thread Decibel!
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

Re: [SQL] Table transform query

2007-09-19 Thread Nis Jørgensen
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,