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

From: <steven_pannel(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject:
Date: 2002-08-05 21:51:19
Message-ID: 20020805215119.33986.qmail@web10707.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Just a quick, silly question about something that has
been driving me insane for the past 20 minutes: why
does the following generate an error in postgresql
6.5?

create table test2(city varchar(35) NULL );

I am using a program which is supposed to work with
postgresql as a database backend but it generates
queries like that which seem to fail on postgresql
6.5. The error is 

ERROR:  parser: parse error at or near "null"

(NOT NULL instead of NULL works fine btw)

Is this only supposed to work in the newer versions or
is the query just plain wrong in any version of
postgresql?


__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com

Responses

  • Re: at 2002-08-06 19:02:57 from Ron Johnson
  • Re: at 2002-08-07 03:12:29 from Tom Lane

pgsql-novice by date

Next:From: DenisDate: 2002-08-06 14:58:51
Subject: initdb fails
Previous:From: Bruce MomjianDate: 2002-08-04 00:43:30
Subject: Re: [SQL] Aggregates and Indexes

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