Mario Splivalo написа:
> I have found, I thinl, in the pg manual, the way to get the number of
> rows inserted/updated, from within the plpgsql. I can't find it anymore,
> is that still there, or I misread something earlier?
>
> Mario
May be this one?
http://www.postgresql.org/docs/8.1/stat
am 01.05.2006, um 18:07:17 +0200 mailte Mario Splivalo folgendes:
> I have found, I thinl, in the pg manual, the way to get the number of
> rows inserted/updated, from within the plpgsql. I can't find it anymore,
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATE
I have found, I thinl, in the pg manual, the way to get the number of
rows inserted/updated, from within the plpgsql. I can't find it anymore,
is that still there, or I misread something earlier?
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I c
On Sat, 2006-29-04 at 01:50 -0500, Ben K. wrote:
> On Fri, 28 Apr 2006, Guy Fraser wrote:
>
> >> -- HEAD
> >> insert into linkedlist values(null,1,0);
> >> insert into linkedlist values(1,2,10);
> >> insert into linkedlist values(2,3,20);
> >> insert into linkedlist values(3,4,30);
> >> insert int
Perfect, thanks
I found regex for postgreSql too, it's interesting too
select * from divers
where s_libelle ~* '^t(e|é|ê)'
Oleg Bartunov a écrit :
> On Mon, 1 May 2006, tnodev wrote:
>
>> Hello,
>>
>> I'm using postGre with tables which contain French character
>> (?...). Is there a foncti
On Mon, 1 May 2006, tnodev wrote:
Hello,
I'm using postGre with tables which contain French character (?...). Is
there a fonction which performs a like in replacing ? (e cute) by e ?
to_ascii() should helps you
thanks...
---(end of broadcast)--
If you use a btree index on the column, you should be able to use it in
the like:
http://www.postgresql.org/docs/8.1/interactive/indexes-types.html.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
tnodev a écrit :
> I'm using postGre with tables which contain French character (éèçàù...).
> Is there a fonction which performs a like in replacing é (e cute) by e ?
>
select translate('forêt', 'àâäéèêëîïôöùûü', 'aaaiioouuu');
Change the first word (forêt) by the string you want charac
Hello,
I'm using postGre with tables which contain French character (éèçàù...).
Is there a fonction which performs a like in replacing é (e cute) by e ?
thanks...
---(end of broadcast)---
TIP 6: explain analyze is your friend
