Re: [GENERAL] text formatting in a query, a la sprintf

2006-08-20 Thread Michael Fuhr
On Sun, Aug 20, 2006 at 08:21:18PM -0700, Reece Hart wrote: > On Sat, 2006-08-19 at 16:50 -0600, Michael Fuhr wrote: > > Here's a trivial (and only minimally tested) PL/Ruby function: > > Thanks, Michael. That's a solution I can use. Now I just have to > compile postgresql for ruby support... Y

Re: [GENERAL] Locale, encoding, sort order confusion

2006-08-20 Thread Alvaro Herrera
John Gunther wrote: > >Pretty much any locale (say, en_US for you) with a matching character > >set should work. Unless you go out of your way, this should be the > >default setting. > > >>I've tried a half dozen time-consuming configs without > >>success. > > >Like what? > > For example, wi

Re: [GENERAL] Locale, encoding, sort order confusion

2006-08-20 Thread John Gunther
Pretty much any locale (say, en_US for you) with a matching character set should work. Unless you go out of your way, this should be the default setting. I've tried a half dozen time-consuming configs without success. Like what? For example, with all LC_* parameters set to "en_US.UTF8",

Re: [GENERAL] apostrophes and psql variables

2006-08-20 Thread Q Beukes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You must have missed one, because: root=# \set tv1 '\'testval\'' root=# insert into test values(:tv1); INSERT 0 1 root=# Ilja Golshtein wrote: > Hello! > > Is there any way to have psql variable in apostrophes? > > The idea is to do something like t

Re: [GENERAL] Locale, encoding, sort order confusion

2006-08-20 Thread Peter Eisentraut
John Gunther wrote: > Can someone tell me what combination of PostgreSQL and Linux settings > I need for this? Or point me somewhere that it's well explained. It > seems like a very basic question, but I'm just dense, > I guess. Pretty much any locale (say, en_US for you) with a matching character