From: | "Michael Black" <mblack(at)distcompsols(dot)com(dot)nospam> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Can anyone explain this |
Date: | 1999-10-31 21:32:05 |
Message-ID: | 5z2T3.45156$7I4.821263@news5.giganews.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)00602(at)dooz(dot)corp(dot)intrinsec(dot)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 !!"
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Black | 1999-10-31 21:42:18 | Not too bright, Request installation assistance. |
Previous Message | nicks.emails | 1999-10-31 17:41:41 | pgsql backend disconnected |