OK, I figured it out. It wasn't the sum(int4) thing...
I have a query that looks like this:
select pnum from part where func1(pnum) and func2(pnum);
Func1 takes less time to execute than func2. I was using func1 to
"narrow the field" of records so the query would not take so long to
execute.
Any reason why I should expect grants and/or revokes to be slower under
7.1RC3?
I have a script that grants all our privileges and it takes about 5 to
10 times longer to run than it did under 7.0.3.
begin:vcard
n:Bateman;Kyle
x-mozilla-html:FALSE
org:Action Target Inc.
adr:;;
version:2.1
Folks (esp Jan, Tom & Michael):
I have a search function I'm testing, which uses the EXECUTE function to
perform a dynamic set of string comparisons according to whcih criteria
the user passes along. Unfortunately, this requires me to triple-nest
my quotes and I can't seem to get it right.
Is there any possibility to cast numeric to text in Postgres 7.0.3?
shop=# select cast(price as text) from products;
ERROR: Cannot cast type 'numeric' to 'text'
Hans
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Respected Sir/Madam,
I visit your site find a lot of information. I
download postgres7.0.3 latest version and install it on Redhat6.1 server. I
follow all the steps in your Install file.
I create a database by createdb
testdb command.
After that I connect it by 'psql
testdb' comman
Is there any possibility to access a column using the alias for the
column in the where clause?
Queries like that don't seem to work:
SELECT name || ' bought ' || amount || ' units' AS result FROM sales
where
result='abc';
ERROR: Attribute 'result' not found
That works perfectly well:
SELECT n
Hello,
I am using postgreSQL 7.02 on RH Linux 6.2.
I have noticed that dumping out a table containing oid (BLOBs) makes
trouble.
How can I managed this in order to have my BLOBs backed up correctly ?
If I don't take care, I have a table with oid that don't point on any
object id (relation does n
The Brand-X DBMS have 'indexed views' but in all their explanations I can't
see where they would be useful. SQL Server 2000 creates a 'clustered index'
on the view, then lets you create other unclustered indexes in addition to
it. Any time one of the source tables is updated, the clustered index
In article <[EMAIL PROTECTED]>, "Josh Berkus"
<[EMAIL PROTECTED]> wrote:
> Tom, Gordon,
> Hmmm ... I'm pretty used an external WHERE clause being applied to the
> output of the view, rather than pushed down into the member selects of
> the UNION, in the same way as if the UNION query were a subs
I read your document about the porting from Oracle to PgSql and I would
like to know if
you can say to me if there is an equivalent on an the option NOWAIT for
a request
SELECT ... FOR UPDATE (for Oracle) under PgSql.
This option don't wait a previus unlock and return the information like
the
Hi,
I recently posted this same question a few weeks back but lost the reply
someone kindly sent. The question again how exactly does this query work:
it will return all attributes and respective data types of a given table':
select attname, typname
from pg_class c, pg_attribute a, pg_type t
wh
On Sun, Apr 01, 2001 at 01:21:43PM -0400, Stef Telford wrote:
> maybe i am naive in thinking this way, but surely the a database function
> formatting the returned string must be quicker then perl. (speaking
> generically of course, i conceed that there are times when the reverse
> is true)
Form
12 matches
Mail list logo
