Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.

Sorry if this shows up twice... I posted last night but it had not 
appeared this morning.

Tks
Dwayne


Fri, 04 Jan 2002 09:17:00 -0500
"Dwayne Miller" <dmiller@espgroup.net>
Syntax changes in 7.2
Dwayne Miller wrote:
> Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
> noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.
> 
> Sorry if this shows up twice... I posted last night but it had not 
> appeared this morning.

Syntax changes are documented at the top of the HISTORY file and in the
release notes at:

	http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-2


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 4 Jan 2002 13:22:41 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Syntax changes in 7.2
Well, if it matters...  I did not see a change posted that would account 
for the difference in operation.  time has been a datatype in both, yet 
the 7.1.x versions would allow a column named time, with no quotes 
required.  7.2 does not.  Guess I'll change the name of that column.

Tks
Dwayne

Bruce Momjian wrote:

>Dwayne Miller wrote:
>
>>Are syntax changes from 7.1.x to 7.2 documented anywhere?  I just 
>>noticed that 'time' as a column name does not work the same in 7.2 as 7.1.x.
>>
>>Sorry if this shows up twice... I posted last night but it had not 
>>appeared this morning.
>>
>
>Syntax changes are documented at the top of the HISTORY file and in the
>release notes at:
>
>	http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-2
>
>



Fri, 04 Jan 2002 14:32:09 -0500
"Dwayne Miller" <dmiller@espgroup.net>
Re: Syntax changes in 7.2
Here some hacky code to generate diffs of the grammar rules. Maybe it
appears to be usefull:

#! /bin/sh

# shell script to diff grammars
# usage:  $0 grammar-old.y grammar-new.y

TMPDIR="/tmp/diffgrammar.$$"

PWD=`pwd`

AWKCODE='
BEGIN { RULE=""; } 
/^rule/ { 
   if ( RULE != $3 ) { print $3" ->"; RULE = $3 }; 
   match($0,/^rule[\ \t]*[0-9]+[\ \t]*[@A-Za-z_0-9]+[\ \t]*->[\ \t]*/); 
   print "\t\t"substr($0,RLENGTH);
}
'
mkdir -p ${TMPDIR}/old ${TMPDIR}/new

cp $1 ${TMPDIR}/old
cp $2 ${TMPDIR}/new

cd ${TMPDIR}/old
bison -v `basename $1`

awk "${AWKCODE}" *.output > grammar.rules

cd ${TMPDIR}/new
bison -v `basename $2`

awk "${AWKCODE}" *.output > grammar.rules

cd ${TMPDIR}
diff -u old/grammar.rules new/grammar.rules

cd ${PWD}
rm -rf ${TMPDIR}

-- 
Holger Krug
hkrug@rationalizer.com

Mon, 7 Jan 2002 08:05:35 +0100
Holger Krug <hkrug@rationalizer.com>
Re: Syntax changes in 7.2