Обсуждение: 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 * 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
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 >
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 >
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 ==========================================================================