Quoth [EMAIL PROTECTED] ("TJ O'Donnell"):
> When I psql -f f.sql
> I get the following error:
> psql:f.sql:10: ERROR: relation "fragset" does not exist
> CONTEXT: SQL function "fragments"
>
>> cat f.sql
> Create Or Replace Function fragments(character varying)
> Returns setof character varying
>
PgAdmin probably encloses all querys in transactions. Do you?
If not, try execute "BEGIN" and "COMMIT" just before and after your
query..
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> Is there some fundamental reason for round(dp) but round(numeric,int)?
I think the main argument against supporting round(dp,int) is that the
result would be inherently inexact (at least for int>0).
regards, tom lane
--
TJ O'Donnell wrote:
I received the following error when executing a SQL statement:
SQL error:
ERROR: function round(double precision, integer) does not exist
In statement:
select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
round((parameter*oe_count_matches(smiles,smarts))
TJ,
> SQL error:
> ERROR: function round(double precision, integer) does not exist
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
> If I use round() without a second argument, it works OK, but
> this gives a loss of precision which
the round sintax is
round(numeric,int)
not
round (double,int)
you must cast the value into numeric:
ex: round (cast(doublecolumn as numeric),2) should work ok
Adrian Din,
Om Computer & SoftWare
On Sun, 27 Feb 2005 15:26:07 -0800, TJ O'Donnell <[EMAIL PROTECTED]> wrote:
I received the following err
I got round(numeric,int) working OK, but it's got me thinking (a dangerous
thing!).
Is there some fundamental reason for round(dp) but round(numeric,int)?
Shouldn't they be, at least, consistent, having round(numeric)
or round(dp,int)?
Am I missing something?
Thanks,
TJ
Michael Fuhr wrote:
On Sun,
TJ O'Donnell wrote:
>
> I received the following error when executing a SQL statement:
>
> SQL error:
> ERROR: function round(double precision, integer) does not exist
>
> In statement:
>
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
> round((parameter*oe_coun
Thanks everyone. Your tips about casting my arg to round()
as ::numeric worked just fine. I guess I was surprised
that plpgsql didn't that on it's own! I'm used to too
many forgiving c compilers, and such.
TJ
Christoph Haller wrote:
TJ O'Donnell wrote:
I received the following error when executi
On Sun, Feb 27, 2005 at 03:26:07PM -0800, TJ O'Donnell wrote:
> ERROR: function round(double precision, integer) does not exist
[snip]
> The functions described at:
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric
select t0_o.scheduler_action_id from scheduler_action t0_o where
t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921::numeric;
seems to work in
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
The reason that this query worked in hpux without the explicit
casting is maybe hp
> CREATE TABLE "scheduler_action" (
>"scheduler_action_id" numeric(30) NOT NULL,
>"action_type" numeric(4) NOT NULL,
>"priority" numeric(4) NOT NULL,
>"referenced_id"numeric(30) NOT NULL,
>"invocation_date" numeric(30) NOT NULL,
>"is_done"
"comp" <[EMAIL PROTECTED]> writes:
> but after connection when I type testdb=3D>\df it gives this error:
> " ERROR: Function 'oid8types(oidvector)' does not exist.
Use the version of psql that came with 7.0.3, not some older version.
regards, tom lane
--
13 matches
Mail list logo
