pgbash-2.4a.2 released

From: SAKAIDA Masaaki <sakaida(at)psn(dot)co(dot)jp>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: pgbash-2.4a.2 released
Date: 2002-07-22 03:30:22
Message-ID: 20020722122552.226C.SAKAIDA@psn.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-07-22 03:33:36 Re: pgbash-2.4a.2 released
Previous Message Christopher Kings-Lynne 2002-07-22 02:22:40 Re: Demo patch for DROP COLUMN