Hi Michael & Tom,
First of all, thanks to Michael for your response. I did enable logging of
SQL queries but still I could find no SQL statements in the logs. This led
me to believe it was a client-side error. Then I saw the response from Tom
which confirmed what I was thinking, so my second set o
or if you want it in the one query:
create table _t(f varchar(50));
select f, case when substr(f, length(f), 1)= substr(f, length(f)-1, 1) then
regexp_replace(f, substr(f, length(f), 1)||'+$', substr(f, length(f), 1))
else f end from _t where length(f)>1;
On 5/8/07, A. Kretschmer <[EMAIL P
On 5/8/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
Right now the software that does the extracts is developed by our
applications developers, but I'll be taking that onto my side in the
near future, just looking for a workaround until then.
Sorry, but there isn't one. An unqualified COPY expec
On Saturday 05 May 2007 01:57, Tom Lane wrote:
> Gary Stainburn <[EMAIL PROTECTED]> writes:
> > I have the query below which when run takes approx 3 seconds. However
> > when I add the condition 'and w_ws_id = 10' onto the end changes to 30+
> > seconds. Can anyone see why? I've included the expla
am Tue, dem 08.05.2007, um 17:48:47 +0530 mailte Penchalaiah P. folgendes:
>
>
>
>
>
>
>
>
> In a table, a column contains
>
>
>
> Suneelll
>
> Sudhakarr
>
> Vivekk
>
> Ramana
>
>
>
>
>
> But my output is
>
> Suneel
>
> Sudhakar
>
>
In a table, a column contains
Suneelll
Sudhakarr
Vivekk
Ramana
But my output is
Suneel
Sudhakar
Vivek
Ramana
I want a query to get my output like above
Please solve my problem ASAP
Regards
penchal
