Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Kenneth Gonsalves) would
write:
> On Tuesday 20 January 2004 19:26, Chris Bowlby wrote:
>> Under 7.3.x this option was removed, you need to test via:
>>
>> SELECT * from table where field IS NULL;
> thanx - works in both 7.1 and 7.3 - wh
--- Guy Fraser <[EMAIL PROTECTED]> wrote:
> Kenneth Gonsalves wrote:
>
> >On Tuesday 20 January 2004 19:26, Chris Bowlby
> wrote:
> >
> >
> >>Hi Ken,
> >>
> >> Under 7.3.x this option was removed, you need to
> test via:
> >>
> >> SELECT * from table where field IS NULL;
> >>
> >>
> >thanx -
Kenneth Gonsalves wrote:
On Tuesday 20 January 2004 19:26, Chris Bowlby wrote:
Hi Ken,
Under 7.3.x this option was removed, you need to test via:
SELECT * from table where field IS NULL;
thanx - works in both 7.1 and 7.3 - why do these guys keep fooling around
with these thangs?
Stan
To achieve a higher level of SQL compliancy..
On Tue, 2004-01-20 at 10:24, Kenneth Gonsalves wrote:
> On Tuesday 20 January 2004 19:26, Chris Bowlby wrote:
> > Hi Ken,
> >
> > Under 7.3.x this option was removed, you need to test via:
> >
> > SELECT * from table where field IS NULL;
> thanx - wo
On Tuesday 20 January 2004 19:26, Chris Bowlby wrote:
> Hi Ken,
>
> Under 7.3.x this option was removed, you need to test via:
>
> SELECT * from table where field IS NULL;
thanx - works in both 7.1 and 7.3 - why do these guys keep fooling around
with these thangs?
--
regards
kg
http://www.ooty
On Tue, Jan 20, 2004 at 07:13:12PM +0530, Kenneth Gonsalves wrote:
> in postgres7.1 i had a table where an integer field could be null. There was
> no default value. a select statement like so:
> 'select * from table where field = null'
> would give all the rows where that field had no value.
> o
On January 20, 2004 08:43 am, Kenneth Gonsalves wrote:
> in postgres7.1 i had a table where an integer field could be null. There
> was no default value. a select statement like so:
> 'select * from table where field = null'
> would give all the rows where that field had no value.
> on porting to 7
Hi Ken,
Under 7.3.x this option was removed, you need to test via:
SELECT * from table where field IS NULL;
On Tue, 2004-01-20 at 09:43, Kenneth Gonsalves wrote:
> in postgres7.1 i had a table where an integer field could be null. There was
> no default value. a select statement like so:
>
in postgres7.1 i had a table where an integer field could be null. There was
no default value. a select statement like so:
'select * from table where field = null'
would give all the rows where that field had no value.
on porting to 7.3.2, this doesnt work. How to do this?
--
regards
kg
http://
