Hey Nicolas,
great answer.
At least it gives some hope,
because it is possible to compute value in plpgsql function and create on
the fly a querry with those values hard written.
I still don't know if it would work with geometry tough
Thanks,
Rémi-C
2015-04-02 10:59 GMT+02:00 Nicolas Ribot
Hi Remy,
As far as I understood table partitionning has one limiting caveat for some
usages (from:
http://www.postgresql.org/docs/9.4/static/ddl-partitioning.html):
Constraint exclusion only works when the query's WHERE clause contains
constants (or externally supplied parameters). For example,
Yes, hope I only understand now, by using anonymous code block to provide
WHERE clauses with constant values...
Some months ago I found this constant-value limitation too strong and did
not use partitionning... ;)
Nicolas
On 2 April 2015 at 11:09, Rémi Cura remi.c...@gmail.com wrote:
Hey
Hi Remi
I might be off the mark with what you are trying to achieve.
One thing I've experimented with, which is allied to vector tiling, is to
assign tile IDs to features, based on various spatial relationships, and to use
the tile id to index and subset the tables prior to doing other stuff.
All,
Oh, geez, I just realized I wrote my answer using syntax from two different
functions.
It should have been more like what Dylan responded with . . . sorry to
introduce confusion . . .
Bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On
Hi Dylan. It worked. I thought I tried that yesterday but I probably did
something wrong.
Thank you very much for your answers,
Regards,
Daniel
On Thu, Apr 2, 2015 at 11:00 AM, Dylan Adams dylan.ad...@gmail.com wrote:
You'll need to use an UPDATE to accomplish what you're trying to do.
You'll need to use an UPDATE to accomplish what you're trying to do. It'll
probably look something like this
UPDATE Table1
SET geom = Table2.geom
FROM Table2
WHERE Table1.FabID = Table2.FabID;
There's more information in the Postgres' documentation about the UPDATE
statement:
A hint to get you started . .
INSERT INTO tablename VALUES (SELECT something FROM . . . . )
Bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Daniel GIL
Sent: Thursday, April 02, 2015 9:53 AM
To: postgis-users@lists.osgeo.org
Hello, I'm learning SQL/PostGIS and I need some help...
I have a table (Table1) with different fields (but no geometry field). This
table has already 35 rows of values.
I imported a second Table to the same database in pgAdmin using
pgShapeLoader. This second table has a geom field that I want