I have just returned from a seven-day trip to Japan.  I spoke for seven
hours to three separate groups, totalling 200 people.  I spoke to a
Linux Conference, a PostgreSQL user's group, and to SRA, a PostgreSQL
support company. You can get more information on my home page under
"Writings".  Here are some pictures from Japan:

	http://www.sra.co.jp/people/t-ishii/Bruce/
        http://ebony.rieb.kobe-u.ac.jp/~yasuda/BRUCE/

PostgreSQL is more popular in Japan than in the United States.  Japan
has user's groups in many cities and has had a commercial support
company (SRA) for two years.  MySQL is not popular in Japan.

It was great to meet so many nice people.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 8 Dec 2000 12:07:56 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Trip to Japan
Bruce,

what was the camera ?

	Regards,
		Oleg
On Fri, 8 Dec 2000, Bruce Momjian wrote:

> Date: Fri, 8 Dec 2000 12:07:56 -0500 (EST)
> From: Bruce Momjian <pgman@candle.pha.pa.us>
> To: PostgreSQL-general <pgsql-general@postgresql.org>
> Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
> Subject: [HACKERS] Trip to Japan
> 
> I have just returned from a seven-day trip to Japan.  I spoke for seven
> hours to three separate groups, totalling 200 people.  I spoke to a
> Linux Conference, a PostgreSQL user's group, and to SRA, a PostgreSQL
> support company. You can get more information on my home page under
> "Writings".  Here are some pictures from Japan:
> 
> 	http://www.sra.co.jp/people/t-ishii/Bruce/
>         http://ebony.rieb.kobe-u.ac.jp/~yasuda/BRUCE/
> 
> PostgreSQL is more popular in Japan than in the United States.  Japan
> has user's groups in many cities and has had a commercial support
> company (SRA) for two years.  MySQL is not popular in Japan.
> 
> It was great to meet so many nice people.
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 8 Dec 2000 20:47:52 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] Trip to Japan
> Bruce,
> 
> what was the camera ?

No idea.  It was not mine.  I brought a video camera, and made 30
minutes of video for my family and company.  I don't know how to make an
MP3 of that.

My wife wants a digital camera now, so it looks like I will have one
soon.  :-)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 8 Dec 2000 12:50:17 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Trip to Japan
> > Bruce,
> > 
> > what was the camera ?
> 
> No idea.  It was not mine.  I brought a video camera, and made 30
> minutes of video for my family and company.  I don't know how to make an
> MP3 of that.
> 
> My wife wants a digital camera now, so it looks like I will have one
> soon.  :-)

Mine is a Nikon "CoolPix990". Originally those pictures had 2048x1536
pixcels that is too much for web pages (~700KB per picture). I
shrinked them to 1024x768 using ImageMagick.

More pictures will be uploaded to the web pages...
--
Tatsuo Ishii

Sat, 09 Dec 2000 10:11:39 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] Trip to Japan
Does the regular expression parser have anything equivalent to Perl's \w
word boundary metacharacter?

I want to select tuples where a text field contains a certail whole word.
Using fieldname ~* 'searchword' wont work because it picks up the
searchword emdedded in other words. Using ~*' searchword ' wont find it at
the beginning or end of the string.
So far we have:
 field ~*' searchword ' OR field ~*'^searchword ' OR field ~*' searchword$' 
but I would like something more elegant.

Steve

-- 
thorNET  - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax:   01454 854412
http://www.thornet.co.uk 

Mon, 11 Dec 2000 11:09:56 +0000
Steve Heaven <steve@thornet.co.uk>
Regular expression question
Steve Heaven <steve@thornet.co.uk> writes:
> Does the regular expression parser have anything equivalent to Perl's \w
> word boundary metacharacter?

src/backend/regex/re_format.7 contains the whole scoop (for some reason
this page doesn't seem to get installed with the rest of the
documentation).  In particular:

	There are two special cases of bracket expressions:
	the bracket expressions `[[:<:]]' and `[[:>:]]' match the null
	string at the beginning and end of a word respectively.
	A word is defined as a sequence of word characters
	which is neither preceded nor followed by word characters.
	A word character is an alnum character (as defined by ctype(3))
	or an underscore.  This is an extension, compatible with but not
	specified by POSIX 1003.2, and should be used with caution in
	software intended to be portable to other systems.
	
	...
	
	BUGS
	
	The syntax for word boundaries is incredibly ugly.

POSIX bracket expressions are pretty ugly anyway, and this is no worse
than the rest.  However, if you prefer Perl or Tcl, I'd recommend that
you just *use* Perl or Tcl ;-).  plperl and pltcl make great
implementation languages for text-mashing functions...

			regards, tom lane

Mon, 11 Dec 2000 10:30:07 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Regular expression question 