Can anyone explain this

Поиск
Список
Период
Сортировка
От Edouard DESSIOUX
Тема Can anyone explain this
Дата
Msg-id 99102413061001.00602@dooz.corp.intrinsec.com
обсуждение исходный текст
Список 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 !!"

В списке pgsql-general по дате отправления:

Предыдущее
От: Atsuko Shono
Дата:
Сообщение: subscribe
Следующее
От: datab@main.kenken.ro
Дата:
Сообщение: Import data from a file