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

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:

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