pgbash-2.4a.2 released

Поиск
Список
Период
Сортировка
От SAKAIDA Masaaki
Тема pgbash-2.4a.2 released
Дата
Msg-id 20020722122552.226C.SAKAIDA@psn.co.jp
обсуждение исходный текст
Ответы Re: pgbash-2.4a.2 released  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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 *
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 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: CREATE/DROP OPERATOR CLASS
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: pgbash-2.4a.2 released