On Wed, 1 Oct 2003, CN wrote:
> > You do realize that extract returns a double precision value not an
> > integer, and it's probably not going to be willing to push clauses down
> > through the union where the types are different .
> >
>
> Argh! I didn't noticed that. Thanks for the reminder.
>
>
"CN" <[EMAIL PROTECTED]> writes:
> Is creating a function that eats DATE as argument to build that index my
> only solution?
You haven't really explained what your problem is. In general I'd not
guess that "year >= X and month >= Y" is a useful operation if Y is
different from 1. You'd be select
Theodore Petrosky <[EMAIL PROTECTED]> writes:
> create rule r1 as on update to table1 do (update
> table2 set jobno = table1.jobno; notify table2;)
> so anyone listening for notifications on table2 can
> ask table2 for the jobno that was updated. then if
> they were viewing that jobno, update thei
> so anyone listening for notifications on table2 can
> ask table2 for the jobno that was updated. then if
> they were viewing that jobno, update their display. if
> not just ignore the notify.
Pardon me if I make your focus blur!
I believe the implementation for such requirement in an application
> You do realize that extract returns a double precision value not an
> integer, and it's probably not going to be willing to push clauses down
> through the union where the types are different .
>
Argh! I didn't noticed that. Thanks for the reminder.
Let's do not consider table2 and view1 for th
I don't know if this is the correct forum for this
question but I will start here...
I have a job tracking system that I am developing with
postgresql and mac os x. I have all the pieces in
place (mostly) but i am having a problem with notify..
I am trying to set up things so that two (or more)
p
Title: Untitled Stationery
please remove my email from your database contacts.
Best Regards,
Vishal
Charan
IT Support
Courts/Homecentres
On Wed, 1 Oct 2003, CN wrote:
> Peter, Thanks a lot!
>
> > Unqualified count() cannot use an index because it has to visit all the
> > rows in the table.
>
> It is only for my test. In my real practice, queries like
> "SELECT * FROM view1 WHERE year = 2003 AND month BETWEEN 10 AND 12"
> will be p
> >-> Seq Scan on table1 (cost=0.00..20.00 rows=1000 width=0) (actual
>
> Run VACUUM ANALYZE, then repost your EXPLAIN ANALYZE results please.
QUERY
PLAN
--
Richard,
> You might want to search the mailing list archives for discussion of an
> oracle version of dblink - I seem to remember someone saying they were
> working on such a thing.
Yes, it'll be out sometime after 7.4. According to their posts in August,
it's in alpha right now and just bare
>-> Seq Scan on table1 (cost=0.00..20.00 rows=1000 width=0) (actual
Run VACUUM ANALYZE, then repost your EXPLAIN ANALYZE results please.
signature.asc
Description: This is a digitally signed message part
"CN" <[EMAIL PROTECTED]> writes:
> The following view is, again, a simplified version. The real version,
> which takes 13 seconds, joins 2 more tables.
You're really doing your best to make sure we don't figure out what's
going on :-(
One thing I can see from your EXPLAIN ANALYZE results, though,
On Wednesday 01 October 2003 16:24, OpenGis wrote:
> Howdy,
>
> I’d like to do (live) link of Oracle table (on win) in Postgres (on RH9
> box).
> In Oracle are stored attribute of my spatial layer collect in
> postgres-postgis geo-database ono-to-one relationship. I use Mapserver
> (http://mapserve
Peter, Thanks a lot!
> Unqualified count() cannot use an index because it has to visit all the
> rows in the table.
It is only for my test. In my real practice, queries like
"SELECT * FROM view1 WHERE year = 2003 AND month BETWEEN 10 AND 12"
will be performed.
> Then again, I don't quite believe
Howdy,
I’d like to do (live) link of Oracle table (on win) in Postgres (on RH9
box).
In Oracle are stored attribute of my spatial layer collect in
postgres-postgis geo-database ono-to-one relationship. I use Mapserver
(http://mapserver.gis.umn.edu) in order to render web map stored in
postgres
"Gordon Ross" <[EMAIL PROTECTED]> writes:
> Is there any way to determine which table a row belows to, if I do a
> search on the top level table:
Look at the built-in column "tableoid". You can join this to
pg_class.oid to retrieve the table name.
regards, tom lane
-
CN writes:
> Table1 contains 9000 rows and table2 contains 0 row. This query, which
> takes 13489 msec, is extremely slow as pgsql sequentially scans all rows
> in table1:
>
> EXPLAIN ANALYZE SELECT COUNT(*) FROM view1;
Unqualified count() cannot use an index because it has to visit all the
rows
Hi!
CREATE TABLE table1
( d DATE PRIMARY KEY,
amount INTEGER
);
CREATE TABLE table2
( PRIMARY KEY (y,m),
y INTEGER,
m INTEGER
amount INTEGER
);
CREATE VIEW view1 AS
SELECT EXTRACT(YEAR FROM d) AS year, EXTRACT(MONTH FROM d) AS month,
amount
UNION ALL
SELECT * from table2;
Table1 contain
Is there any way to determine which table a row belows to, if I do a
search on the top level table:
e.g. I have a table called "BASE". There are two tables which inherit
from "BASE" called "SUBTABLE1" and "SUBTABLE2"
If I do a SELECT * FROM BASE WHERE blah; how can I tell which table
(either SUBT
please remove my email from your database contacts.
Kind Regards,
Mark.
___
Disclaimer: Great Ormond Street Hospital for Children NHS Trust
SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note
that Internet E-mail is simply not a secure communi
please remove my email from your database contacts.
Best Regards,
Naren
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
please remove my email from your database
contacts.
best regards,
etur
22 matches
Mail list logo
