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]
