Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards
Date: 2001-06-07 14:34:33
Message-ID: Pine.LNX.4.30.0106071628100.757-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas SB writes:

> Actually I am not sure whether the column = NULL syntax is even defined
> or allowed in SQL92

I think you're right.

> (e.g. Informix interprets the NULL as column name in this context and
> errs out).

NULL is a reserved word, so this would be wrong.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Forsman 2001-06-07 14:37:36 Re: Re: Daily Digest V1 #1428
Previous Message Vince Vielhaber 2001-06-07 14:23:51 grant and SQL92