Re: pgbash-2.4a.2 released

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: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of SAKAIDA Masaaki
> Sent: Monday, 22 July 2002 11:30 AM
> To: pgsql-hackers(at)postgresql(dot)org
> 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 majordomo(at)postgresql(dot)org
>