
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 


Mon, 22 Jul 2002 12:30:22 +0900
SAKAIDA Masaaki <sakaida@psn.co.jp>
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@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of SAKAIDA Masaaki
> Sent: Monday, 22 July 2002 11:30 AM
> To: pgsql-hackers@postgresql.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@postgresql.org
>


Mon, 22 Jul 2002 11:33:36 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: pgbash-2.4a.2 released

Best would be to get it added as a project on GBorg ... Chris is working
on changes to GBorg to allow a project to be added to the site *without*
it necessarily be 'hosted' there, so that projects like this, or PgAdmin,
can be tracked through on central location, without limiting the
developers themselves ...


On Mon, 22 Jul 2002, Christopher Kings-Lynne wrote:

> 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@postgresql.org
> > [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of SAKAIDA Masaaki
> > Sent: Monday, 22 July 2002 11:30 AM
> > To: pgsql-hackers@postgresql.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@postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


Mon, 22 Jul 2002 02:06:10 -0300 (ADT)
"Marc G. Fournier" <scrappy@hub.org>
Re: pgbash-2.4a.2 released
On Mon, 22 Jul 2002, Christopher Kings-Lynne wrote:

> Would it be worth creating a list of postgres project like this somewhere on
> the postgres site?  I had no idea this existed...

It's been listed forever.  http://www.us.postgresql.org/interfaces.html
It's about the 17th one from the top.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Mon, 22 Jul 2002 05:48:03 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: pgbash-2.4a.2 released