Re: [HACKERS] pgbash-2.4a.2 released

2002-07-22 Thread Vince Vielhaber

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 -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
 56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directoryhttp://www.camping-usa.com
   Online Giftshop Superstorehttp://www.cloudninegifts.com
==




---(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



Re: [HACKERS] pgbash-2.4a.2 released

2002-07-21 Thread Marc G. Fournier


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: [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
>


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] pgbash-2.4a.2 released

2002-07-21 Thread Christopher Kings-Lynne

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



[HACKERS] pgbash-2.4a.2 released

2002-07-21 Thread SAKAIDA Masaaki


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]