[Sussex] Postgresql date fields

G.J. Teale gteale at cmedresearch.com
Thu Oct 27 10:52:06 UTC 2005


"Angelo Servini" <Angelo.Servini at claybrook.co.uk> writes:

---- %< -----

> However, it may be like ORACLE where NULL values are treated as empty string, so
>
> 	Select * from MyTablename where MyDateField = ''

---- %< -----

Burn him.. he is a witch!

'' != NULL

unclean I say, unclean... 

-- 
G. J. Teale
Software Engineering Team Leader

Cmed Group Ltd.
Holmwood, Broadlands Business Campus,
Langhurstwood Road, Horsham, RH12 4QP, United Kingdom

T +44(0)1403 755 071
F +44(0)1403 755 051
M +44(0)7776 195 211
E gteale at cmedresearch.com  
W www.cmedresearch.com
__________________________________________________________

Driven by technology. Guided by experience.
__________________________________________________________
When we talk of tomorrow, the gods laugh.




More information about the Sussex mailing list