Formatting psql output

DEBUG: recycled transaction log file 0000000000000018
DEBUG: ServerLoop: select failed: Permission denied
PGSTATBUFF: select(2)Permission denied
: Permission denied

i have got this
why i have got this error?

Hi ,

I would like to know how to cast as numeric.For examlple

I can use cast as

cast(to_number(substring(os_crm_exchange_call_id, 4), 999999999999) as
smallint)

but here I will have the restriction of the field so If I want to cast it as
numeric how
do I do that.
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

markMLl.pgsql-general@telemetry.co.uk wrote:

I'm sure I'm missing something obvious here, but how can I tell either
the server or psql to limit the number of digits presented in a set of
results? Is there a facility somewhere for applying something like a
printf format string?

We will implement that in 7.4. Not done yet.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman@candle.pha.pa.us> writes:

markMLl.pgsql-general@telemetry.co.uk wrote:

I'm sure I'm missing something obvious here, but how can I tell either
the server or psql to limit the number of digits presented in a set of
results? Is there a facility somewhere for applying something like a
printf format string?

We will implement that in 7.4. Not done yet.

There's always to_char() ...

regards, tom lane

Thanks everybody. It's not urgent (the normal apps are doing their own
thing and I only use psql for maintenance) so for heavens sake /don't/
let it detract from the effort going into replication <grin>.

Tom Lane wrote:

Bruce Momjian <pgman@candle.pha.pa.us> writes:

markMLl.pgsql-general@telemetry.co.uk wrote:

I'm sure I'm missing something obvious here, but how can I tell either
the server or psql to limit the number of digits presented in a set of
results? Is there a facility somewhere for applying something like a
printf format string?

We will implement that in 7.4. Not done yet.

There's always to_char() ...

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or
colleagues]

On Wed, Nov 06, 2002 at 10:47:59 +0000,
markMLl.pgsql-general@telemetry.co.uk wrote:

I'm sure I'm missing something obvious here, but how can I tell either
the server or psql to limit the number of digits presented in a set of
results? Is there a facility somewhere for applying something like a
printf format string?

The to_char function can do this.

On Wed, Nov 06, 2002 at 18:21:08 +0530,
Savita <savita@india.hp.com> wrote:

Hi ,

I would like to know how to cast as numeric.For examlple

I can use cast as

cast(to_number(substring(os_crm_exchange_call_id, 4), 999999999999) as
smallint)

::numeric

numeric has 2 option paramters that allow you to limit the precision
and specify a scale. The default is to not limit precision.

On Wed, 6 Nov 2002, Florian Litot wrote:

DEBUG: recycled transaction log file 0000000000000018
DEBUG: ServerLoop: select failed: Permission denied
PGSTATBUFF: select(2)Permission denied
: Permission denied

It sounds like the ownership of the files is wrong. Do the files in
$PGDATGA/pg_xlog belong to the postgres super user? Does the directory?

Hi all,

I'm trying to find a function that will replace one word with another in a
string.

e.g. select <replace function>('bob was here, bobina wasnt', 'bob', 'mike');
will return "mike was here, mikeina wasnt"

Is there such a function already written in PostGreSQL?

Thanks in advance,
Mark

Mark Wilson wrote:

Hi all,

I'm trying to find a function that will replace one word with another in a
string.

e.g. select <replace function>('bob was here, bobina wasnt', 'bob', 'mike');
will return "mike was here, mikeina wasnt"

Is there such a function already written in PostGreSQL?

It is new in 7.3 (currently in beta). See the function called "replace" at:
http://developer.postgresql.org/docs/postgres/functions-string.html

test=# select replace('bob was here, bobina wasnt', 'bob', 'mike');
replace
------------------------------
mike was here, mikeina wasnt
(1 row)

HTH,

Joe

There is a function called TRANSLATE

This will do the trick

HTH

On Thu, 7 Nov 2002, Mark Wilson wrote:

Hi all,

I'm trying to find a function that will replace one word with another in a
string.

e.g. select <replace function>('bob was here, bobina wasnt', 'bob', 'mike');
will return "mike was here, mikeina wasnt"

Is there such a function already written in PostGreSQL?

Thanks in advance,
Mark

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Darren Ferguson

Darren Ferguson wrote:

There is a function called TRANSLATE

This will do the trick

HTH

TRANSLATE performs a character-by-character replacement. You
cannot use TRANSLATE to substitute words or phrases. Example:

SELECT TRANSLATE('mikei', 'ike', '*8p');

m*8p*

all i's->*
all k's->8
all e's->p

You must either write your own replace(), or use the one
included in 7.3 as Joe Conway mentioned.

Mike Mascari
mascarm@mascari.com

Must be a slow posting day today :~)

Thanks everyone. I'm running PostGreSQL 7.2.1 and have run in the replace
function that numerous people sent me. It works exactly as I would expect
it to.

Cheers,
Mark

----- Original Message -----
From: "Joe Conway" <mail@joeconway.com>
To: "Mark Wilson" <mark@mediasculpt.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, November 07, 2002 11:51 AM
Subject: Re: [GENERAL] replace text function

Mark Wilson wrote:

Hi all,

I'm trying to find a function that will replace one word with another in

a

string.

e.g. select <replace function>('bob was here, bobina wasnt', 'bob',

'mike');

will return "mike was here, mikeina wasnt"

Is there such a function already written in PostGreSQL?

It is new in 7.3 (currently in beta). See the function called "replace"

at:

how i can configure postgre to ahve the maximum of trace?

I know you're sorted with a solution, but the responses must have been
off-list. For the record, and to point others to useful additional
functionality the PostgreSQL Cookbook is always useful and has a
REPLACE function:

http://www.brasileiro.net/postgres/cookbook/
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=8886

Lee.

Mark Wilson writes: