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 !!"
>