please remove my email from your database
contacts.
best regards,
etur
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.
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
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 SUBTABLE1
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
Howdy,
Id 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
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
On Wednesday 01 October 2003 16:24, OpenGis wrote:
Howdy,
Id 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
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, is
- 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
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 barely
- 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
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 performed.
Title: Untitled Stationery
please remove my email from your database contacts.
Best Regards,
Vishal
Charan
IT Support
Courts/Homecentres
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)
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 this
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
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 their
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 selecting a
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.
Let's do
20 matches
Mail list logo