Skip site navigation (1) Skip section navigation (2)

Can anyone explain this

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 (view raw or flat)
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 !!"

Responses

pgsql-general by date

Next:From: Martin WeinbergDate: 1999-10-24 12:16:12
Subject: Re: [GENERAL] Re: Errors in Postgres
Previous:From: Jason C. WellsDate: 1999-10-24 10:42:50
Subject: Re: [GENERAL] UPDATE cell from text file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group