Re: [SQL] Trigger Function and Html Output

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

[SQL] Can anyone explain how this works?

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

[SQL] help

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

[SQL] Re: UNION in a VIEW?

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

[SQL] Re: Index on View ?

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

[SQL] pg_dump and oid

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

[SQL] Aliasing on tables ...

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

[SQL] Sql error

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

[SQL] Casting numeric to text

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

[SQL] Need help with EXECUTE function

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.

[SQL] 7.1 grant/revoke speed

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

[SQL] Update

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.