From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] parser enhancement request for 6.5 |
Date: | 1999-05-10 00:54:27 |
Message-ID: | 199905100054.UAA04457@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Added to 6.5 beta.
> I would like for you to also consider adding the following to gram.y for
> version 6.5:
>
> | NULL_P '=' a_expr
> { $$ = makeA_Expr(ISNULL, NULL, $3,
> NULL); }
>
> I know there was some discussion about this earlier including comments
> against this. Access 97 is now generating the following statement and
> error:
>
> SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5
> 432;UID=kari;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROW
> VERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
> conn=154616224,
> query='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines"
> "RentalOrders" WHERE ( NULL = "rentalorderid" ) '
> ERROR from backend during send_query: 'ERROR: parser: parse error at or
> near "="'
>
>
> The above code changed allows Access 97 to work correctly. I would be happy
> to consider any other possible alternatives.
>
> Thanks, Michael
>
>
> -----Original Message-----
> From: Bruce Momjian [SMTP:maillist(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Saturday, March 13, 1999 10:14 PM
> To: Michael Davis
> Cc: hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] parser enhancement request for 6.5
>
> Applied.
>
>
> [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > I have a problem with Access97 not working properly when entering
> new
> > records using a sub form, i.e. entering a new order/orderlines or
> master and
> > detail tables. The problem is caused by a SQL statement that
> Access97 makes
> > involving NULL. The syntax that fails is "column_name" = NULL.
> The
> > following attachment was provided by -Jose'-. It contains a very
> small
> > enhancement to gram.y that will allow Access97 to work properly
> with sub
> > forms. Can this enhancement be added to release 6.5?
> >
> > <<gram.patch>>
> > Thanks, Michael
> >
>
> [Attachment, skipping...]
>
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
> 19026
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 1999-05-10 00:58:06 | Re: [HACKERS] Re: SIGBUS in AllocSetAlloc & jdbc |
Previous Message | Bruce Momjian | 1999-05-10 00:51:25 | Re: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of frying pan, into fire) |