Thread: Can anyone explain this
Hello, I'm new in using SQL, but i can't figure why ny example does this : manip=> select * from mailing ; file |name |display -----------------------------------------------+------------------------------+------- https://dooz.corp.intrinsec.com/mail/mail_ed/ |Boite aux lettre du compte Ed |t https://dooz.corp.intrinsec.com/mail/mail_crs/ |Boite aux lettre du compte Crs|t https://dooz.corp.intrinsec.com/mail/mail_root/|Boite aux lettre du compte Roo|f https://dooz.corp.intrinsec.com/mail/mail_other|Boite aux lettre anonyme |f https://dooz.corp.intrinsec.com/mail/essai.php3|Recharger cette page |t (5 rows) manip=> insert into mailing values ('a','b',display=true); INSERT 0 5 manip=> select * from mailing ; file |name |display -----------------------------------------------+------------------------------+------- https://dooz.corp.intrinsec.com/mail/mail_ed/ |Boite aux lettre du compte Ed |t https://dooz.corp.intrinsec.com/mail/mail_crs/ |Boite aux lettre du compte Crs|t https://dooz.corp.intrinsec.com/mail/mail_root/|Boite aux lettre du compte Roo|f https://dooz.corp.intrinsec.com/mail/mail_other|Boite aux lettre anonyme |f https://dooz.corp.intrinsec.com/mail/essai.php3|Recharger cette page |t a |b |t a |b |t a |b |f a |b |f a |b |t (10 rows) Why does it insert 5 'b', and what would be the correct syntax to insert only one b And why values for the attribute display are not always true as i said into the command ? -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"
What is the difference between rows 1-2 and 3-5? It appears that rows 3-5 are missing ether a line terminator, such as a <CR> or a trailing space, or the data has filed the column to its maximum length. I can not be for certain about the latter because you did not post a data schema of the table in question. These observations should give you a clue on the resolution required. HTH Michael Black Edouard DESSIOUX wrote in message <99102413061001.00602@dooz.corp.intrinsec.com>... >Hello, > >I'm new in using SQL, but i can't figure why ny example does this : > >manip=> select * from mailing ; >file |name |display >-----------------------------------------------+--------------------------- ---+------- >https://dooz.corp.intrinsec.com/mail/mail_ed/ |Boite aux lettre du compte Ed |t >https://dooz.corp.intrinsec.com/mail/mail_crs/ |Boite aux lettre du compte Crs|t >https://dooz.corp.intrinsec.com/mail/mail_root/|Boite aux lettre du compte Roo|f >https://dooz.corp.intrinsec.com/mail/mail_other|Boite aux lettre anonyme |f >https://dooz.corp.intrinsec.com/mail/essai.php3|Recharger cette page |t >(5 rows) > >manip=> insert into mailing values ('a','b',display=true); >INSERT 0 5 >manip=> select * from mailing ; >file |name |display >-----------------------------------------------+--------------------------- ---+------- >https://dooz.corp.intrinsec.com/mail/mail_ed/ |Boite aux lettre du compte Ed |t >https://dooz.corp.intrinsec.com/mail/mail_crs/ |Boite aux lettre du compte Crs|t >https://dooz.corp.intrinsec.com/mail/mail_root/|Boite aux lettre du compte Roo|f >https://dooz.corp.intrinsec.com/mail/mail_other|Boite aux lettre anonyme |f >https://dooz.corp.intrinsec.com/mail/essai.php3|Recharger cette page |t >a |b |t >a |b |t >a |b |f >a |b |f >a |b |t >(10 rows) > >Why does it insert 5 'b', and what would be the correct syntax to insert >only one b >And why values for the attribute display are not always true as i said into >the command ? > >-- >Edouard DESSIOUX >Proverbe chien : >"Si ca se mange pas, > Si ca se baise pas, > Pisse dessus !!" >