Re: [SQL] Accent-insensitive

2002-12-07 Thread Joel Burton
On Sat, Dec 07, 2002 at 07:06:45PM -0300, Pedro Igor wrote: > Thanks, you know if some possible release would have some internal to deal > with this ? > > Abraços > Pedro Igor > > > > CREATE FUNCTION lower_ascii (text) RETURNS text AS ' > > BEGIN > > RETURN lower(to_ascii($1)); > > END > >

Re: [SQL] SELECT FOR UPDATE locks whole table

2002-12-07 Thread D'Arcy J.M. Cain
On December 6, 2002 02:10 pm, Bruce Momjian wrote: > It should lock only the rows you retrieved, but I have no idea how FOR > UPDATE and INTO TEMP behave. My guess is that it should work fine, but > I have never seen those two used together before. Turns out that it wasn't the SELECT ... FOR UPDA