From: | Edouard DESSIOUX <edx(at)intrinsec(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Can anyone explain this |
Date: | 1999-10-24 11:02:28 |
Message-ID: | 99102413061001.00602@dooz.corp.intrinsec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Martin Weinberg | 1999-10-24 12:16:12 | Re: [GENERAL] Re: Errors in Postgres |
Previous Message | Jason C. Wells | 1999-10-24 10:42:50 | Re: [GENERAL] UPDATE cell from text file |