Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions select AddGeometryColumn(...); described in:
http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html
Ludwig
Am 17.01.2011 18:35, schrieb Plata Martínez, Álvaro (KNMI):
Hi,
Using
Just some thoughts:
- create a multipoint with 100 vertices instead of a single point and query
once with st_Intersect
- prepare the single-point-query and execute the prepared query 100 times with
the changing coordinates
Ludwig
- Ursprüngliche Nachricht -
Von: trevor1940
Gesendet
= $target_file_name;
while(file_exists($target_dir . '/' . $target_file_name)){
$i++;
$target_file_name = $i . $old_target_file_name;
}
return $target_file_name;
}
/SNIP
Ludwig
« für »MI«
DETAIL: Der Wert muss eine ganze Zahl sein.
Regards
Ludwig
Am 07.07.2010 23:07, schrieb Carlos Henrique Reimer:
Hi
I've a Linux box running postgresql 8.2.17 and facing some strange
results from the to_date function.
As you can see in the following tests the problem occurs when
be done? I'm runnig PG 8.4 on a windows machine.
Regards
Ludwig
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I don't know about Postgres 8.3, but with 8.4-docs the Syntax of your
query could be
select * from tblretrain where NOT ('ms-ap-t2-02c9' = ANY (owners));
regards
Ludwig
Grant Maxwell schrieb:
Hi Folks
According to the 8.3 docs I should be able to write:
select * from tblretrain where 'ms
inner join test_right as t3 on t1.token = t3.token and t1.exponent =
t3.exponent
inner join test_right as t4 on t2.token = t4.token and t2.exponent =
t4.exponent;
Regards
Ludwig Kniprath
Alban Hertroys schrieb:
Greetings!
I'm having some troubles creating a query, or rather, I can write one
Scott Marlowe schrieb:
On Sat, May 23, 2009 at 7:18 AM, Christophe x...@thebuild.com wrote:
On May 23, 2009, at 9:13 AM, Daniel Verite wrote:
I don't know why this query returns false:
SELECT '20040506 070809.01'::timestamp(6) - '20010203
040506.007000'::timestamp(6) = '1188 day 3
Hello Hendra,
there is no function right(column, n-Chars), but you can use
substring(column-name from offset for num_chars) in combination with
char_length for getting the right-n-characters as f. e.:
select substring(column from (char_length(column) - 3) for 4) from table
Ludwig
Dear all
I don't know, if this is an inconsistence or a bug, but here a possible
workaround:
select current_timestamp::abstime::int4 as score,
current_timestamp::abstime::int4 + 1 as score + 1 order by score + 1;
Ludwig
This works:
critik=# select current_timestamp::abstime::int4
looking at the data above (only
river_1 is running through all these countries), but how to query this
by sql?
Thanks in advance
Ludwig
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
= 'name_of_your_table' and
column_name = 'name_of_your_column'
bye...
Ludwig
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hallo Bob,
I also use pgDmin on XP with postGIS and imported Shape-Files, but without
problems.
As far as I know pgadmin uses gtk, and there are some google-hits for
searchvalues pgadmin and gtk reporting hardware-crashes on windows and
linux Systems.
Perhaps the same problem?
Ludwig
MS's web
Perhaps trivial, but:
Additional to or instead of triggers You can use grants to allow updates only
to special users.
Ludwig
Hello there
Can anyone please tell me how to make a column uneditable..
Plz give me some output
thans
--
Sent via pgsql-general mailing list (pgsql-general
Hi,
I think, this is the wrong list, it appears to be a PHP error.
Anyway, try to put the global $_SERVER['SCRIPT_NAME'] into {}brackets:
list($page_id)=sqlget(select page_id from pages where
name='{$_SERVER['SCRIPT_NAME']}');
Hope, You're not lost anymore ...
Ludwig
PJ schrieb:
I'm using
, somehow the credentials must be cleartext, so you cant get rid of this lack of security in my opinion.By the way, this is an *intra*net-solution, and we dont have hackers in our staff, I hope...Ludwig
...Ludwig
Type casting is required since 8.3, trySELECT substring(date :: varchar from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASCBye...LudwigHi there, it seems to work with 8.1, but not anymore with 8.3. What is
Yes, there is a great solution,take a look at PostGIS: http://www.postgis.org/It shurely will do all you want with geodata, but perhaps not as simple as you like...bye...LudwigHello,I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. Is store them as numeric at this
Hi,whats the result of SELECT * from tmp_stamp where _stamp = 2f980de9f2297c7902f3415f6537c6be;?Perhaps different fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs versus CHAR(n) in Table _stamp filled up with blanks)?LudwigHi,there is a problem with foreign key (PG 8.3RC2). Please, look at
ROLE. For example, being a member of a role with CREATEDB privilege does notimmediately grant the ability to create databases, even if INHERIT is set; it would be necessary tobecome that role via SET ROLE before creating a database.bye...Ludwig
Devrim GUNDUZ schrieb:
Hello,
On Tue, 2006-10-10 at 11:30 +0200, Ludwig Kniprath wrote:
/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1: libgeos_c.so.1: cannot
open shared object file: No such file or directory
Did you run make install agains geos? Is the path that libgeos_c.so.1
PostgreSQL 8.1 on ubuntu-linux 6.06 (kernel 2.6.15-27-686):
Compiled proj-4.4.9 and geos-2.2.3 without problems.
Output from postgis-./configure-Command:
SUMMARY
---
HOST_OS: linux-gnu
PGSQL: /usr/bin/pg_config
GEOS:
in advance,
ludwig lim
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
Hi Thomas :
--- Thomas Kellerer [EMAIL PROTECTED] wrote:
Ludwig Isaac Lim wrote on 15.08.2006 18:05:
Searching the web using google gives me the following
information about error 1063:
Error code 1063:
ERROR_FAILED_SERVICE_CONTROLLER_CONNECT -
I had a similar issue several weeks ago
Hi :
Maybe you forget to run the ANALYZE command afterwards.
ludwig.
--- Philippe Lang [EMAIL PROTECTED] wrote:
Hi,
For an unknown reason, I cannot post this message to the
mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Cheers,
Philippe Lang
Hi:
How about the postgresql.conf settings? Did you changed
them?
ludwig.
--- Philippe Lang [EMAIL PROTECTED] wrote:
Hi,
I did not mention it in my first email, but I did run
ANALYSE before
running the query... So statistics are just fine for the
execution plan
engine.
Philippe
(check
http://www.powerpostgresql.com/PerfList) .
ludwig.
--- Philippe Lang [EMAIL PROTECTED] wrote:
Hi,
I have now disabled hyperthreading in /etc/grub.conf
(added noht at the end
of kernel lines), rebooted the server, run ANALYSE on the
database again,
and launched the query: things are even
.
select a,sum(b) as sum_b
from c
group by a
order by a, sum_b
ludwig lim
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast
Hi :
How about creating a view that converts integer into
numeric?
create view name as
select col1::numeric as col1,
select col2::numeric as col2
...
and then query the view instead. This way your formula
doesn't need to use cast anymore.
ludwig lim
--- SunWuKung [EMAIL PROTECTED] wrote
in creating a new
database.
Am I missing something here?
Thank you very much,
ludwig lim
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast
, should one vacuum template1 when
vacuuming other database (Assuming one doesn't use vaccumdb
script when vacuuming database)?
Will this problem occur if I vacuum all database except
template1?
Thanks for the previous quick response.
Thank you once again.
ludwig lim
://archives.postgresql.org/pgsql-patches/2005-04/msg00034.php).
psql --version
psql (PostgreSQL) 8.0.4
Was the patch for version 8.1? I'm just wondering why
the patch was not applied to PostgreSQL version 8.0.4
Thank you!
Ludwig Lim
have saved them.
Logged in as user ludwig I can insert data with no problem.
But as my small Perl-program tries to connect to the database, that does
not work. postgres.log: Peer authentication failed for user 'ludwig'
What to do?
Ludwig
---(end of broadcast
looking for is $#ports then ...
I think this method will take a lot of time and is not very effective, as
I do not think I wil ever access one of the entrys read (at least not
while putting some information) ...
Saluti!
Ludwig
---(end of broadcast
Hallo!
I temporary solved the problem with the sequences by making a query:
select id from ports order by id desc limit 1;
But I am not convinced this is the real way to get the number of element
the table ports has
Saluti!
Ludwig
---(end of broadcast
,
and-so-on references all-other-tables
);
How, each time You insert some data in huibui using
insert into huibui (field1, and-son-on) values (?, ..);
the 'tralala' counter will be increased by one (nextval).
Saluti!
Ludwig
---(end of broadcast)---
TIP
tables.
Maybe someone can help?
Saluti!
Ludwig
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
38 matches
Mail list logo