Would it be worth creating a list of postgres project like this somewhere on the postgres site? I had no idea this existed...
Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of SAKAIDA Masaaki > Sent: Monday, 22 July 2002 11:30 AM > To: [EMAIL PROTECTED] > Subject: [HACKERS] pgbash-2.4a.2 released > > > > I'm pleased to announce the release of pgbash-2.4a.2. > http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html > > ChangeLog: > > 1.Add "REINDEX" as a SQL reserved word. > > 2.Fix a bug of the single/double quotaion surrounded by the > double/single quotation. > ex.) > insert into "test" values(123,'name"name'); > select code as "He's code" from test where name='sanme"name'; > > 3. Add the functionality of processing the single quotation > data surrounded by \'. > ex.) > DATA="I can't" > select * from test where mesg=\'$DATA\'; > > # A bug of "REINDEX" was reported by ISHIDA akio. > # A bug of single/double quotation was reported by Tomoo Nomura. > > > (examples) > DATA1="sakaida's" > DATA2='kobe"desu' > insert into "test" values(111,'sakaida''s','kobe"desu'); > insert into "test" values(111,\'$DATA1\',\'$DATA2\'); > > DATA1="sakaida''s" > DATA2='kobe"d"esu' > insert into "test" values(111,'sakaida''s','kobe"d"esu'); > insert into "test" values(111,\'$DATA1\', '$DATA2' ); > > select * from test; > select * from test where name=\'$DATA1\'; > select code as "code's" from test where name=\'$DATA1\'; > > -- > SAKAIDA Masaaki > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly