Thread: Syntax changes in 7.2
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
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, Pennsylvania19026
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 > >
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