hi
Hello again,
Tarlika.
In what concerns to indices, I 'm affraid I may not be the best person to
advise you, my knowledge of them hardly goes beyond the most trivial cases.
I'm sure there are plenty of other people on the list who are able to give
you better advise than me.
But, on this query
Hi,
> And as bonus ... is there a way to find IDs that are in the list but not
> in the table without creating a temporary table and use a join?
Does below satisfy you?
select * from (values (1), (2), (3), (5), (7), (11), (3),
(6), (13), (13), (3), (11)) as X(a)
where a not in(select id from m
On Tue, 28 Sep 2010 11:34:31 +0100
"Oliveiros d'Azevedo Cristina" wrote:
>- Original Message -
>From: "Tarlika Elisabeth Schmitz"
>To:
>Sent: Monday, September 27, 2010 5:54 PM
>Subject: Re: [SQL] identifying duplicates in table with redundancies
>
>
>> On Fri, 24 Sep 2010 18:12:18 +01
Dear List,
I have created a database with the template postgis.
In this database a shema named ‘public’ was created, with the functions of
postgis and two tables (geometry_columns and spatial_ref_sys).
Now, I would like to create one shema like this for every village.
How can I add a s