Thread: pgbash-2.4a.2 released

pgbash-2.4a.2 released

From
SAKAIDA Masaaki
Date:
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 *
fromtest 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 



Re: pgbash-2.4a.2 released

From
"Christopher Kings-Lynne"
Date:
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
>



Re: pgbash-2.4a.2 released

From
"Marc G. Fournier"
Date:
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
>



Re: pgbash-2.4a.2 released

From
Vince Vielhaber
Date:
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
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================