[DOCS] German FAQ update...
...attached. It's rather large because I've changed the encoding to UTF-8 to match the server encoding. Note: the link http://store.pgsql.com/shopping/ still does not work. Don't forget to update the version number in FAQ 1.7 to 8.0 in the other FAQs before packaging! Ian Barwick [EMAIL PROTECTED] FAQ_german.html.cdiff.bz2 Description: BZip2 compressed data ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[DOCS] FAQ doesn't mention ALTER COLUMN TYPE
Question 4.4 in the FAQ, "How do you remove a column from a table, or change its data type?" doesn't mention 8.0's ability to alter a column's type with ALTER TABLE tab ALTER COLUMN col TYPE new_type. Since 8.0 is coming up the FAQ should probably mention this. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] German FAQ update...
Thanks, updated, and main FAQ marked for 8.0.0. --- Ian Barwick wrote: > > ...attached. It's rather large because I've changed the encoding to UTF-8 > to match the server encoding. > > Note: the link http://store.pgsql.com/shopping/ still does not work. > > Don't forget to update the version number in FAQ 1.7 to 8.0 in the > other FAQs before packaging! > > Ian Barwick > [EMAIL PROTECTED] [ Attachment, skipping... ] > > ---(end of broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] FAQ doesn't mention ALTER COLUMN TYPE
Michael Fuhr wrote: > Question 4.4 in the FAQ, "How do you remove a column from a table, > or change its data type?" doesn't mention 8.0's ability to alter a > column's type with ALTER TABLE tab ALTER COLUMN col TYPE new_type. > Since 8.0 is coming up the FAQ should probably mention this. Good point. Done. -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
