pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
date not initialized 2+ messages / 2 participants [nested] [flat]
* date not initialized @ 1999-06-10 14:28 Roland_DUBOULOZ <Roland.Dubouloz@bull.net> 0 siblings, 0 replies; 2+ messages in thread From: Roland_DUBOULOZ @ 1999-06-10 14:28 UTC (permalink / raw) To: pgsql-interfaces I have a table like this : table boocks (name varchar , return_date date) The field return_date is not initialized : insert into books values (name1); insert into books values (namex); The field return_date is updated when the books is returned like this : update books set return_date='10-06-1999' where name=xxx; How can i select all the item where the return_date is not updated ? a request like this : select * from books where return_date='' ???? (actually i initialised the return_date with the values '01-01-0001') thank you. -- Roland Dubouloz BULL XS/BU BULL SA mailto:Roland.Dubouloz@bull.net 1,Rue de Provence Phone :+33 (0)4 76 29 77 87 BP 208 Bullcom : 229-7787 38432 Echirolles CEDEX Office : A1-052 France Fax : +33 (0)4 76 29 70 02 ^ permalink raw reply [nested|flat] 2+ messages in thread
* date not initialized @ 1999-06-10 14:54 Roland_DUBOULOZ <Roland.Dubouloz@frec.bull.fr> 0 siblings, 0 replies; 2+ messages in thread From: Roland_DUBOULOZ @ 1999-06-10 14:54 UTC (permalink / raw) To: pgsql-interfaces I have a table like this : table boocks (name varchar , return_date date) The field return_date is not initialized : insert into books values (name1); insert into books values (namex); The field return_date is updated when the books is returned like this : update books set return_date='10-06-1999' where name=xxx; How can i select all the item where the return_date is not updated ? a request like this : select * from books where return_date='' ???? (actually i initialised the return_date with the values '01-01-0001') thank you. -- Roland Dubouloz BULL XS/BU BULL SA mailto:Roland.Dubouloz@bull.net 1,Rue de Provence Phone :+33 (0)4 76 29 77 87 BP 208 Bullcom : 229-7787 38432 Echirolles CEDEX Office : A1-052 France Fax : +33 (0)4 76 29 70 02 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-06-10 14:54 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-06-10 14:28 date not initialized Roland_DUBOULOZ <Roland.Dubouloz@bull.net> 1999-06-10 14:54 date not initialized Roland_DUBOULOZ <Roland.Dubouloz@frec.bull.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox