Shane wrote:
Hi,
I am attempting a query using lseg values to find the point
of intersection. The following query taken from the PG
manual isn't working over here.
select
point(lseg '((-1,0),(1,0))', lseg
'((-2,-2),(2,2))')
ERROR: function point(lseg, lseg) does not exist
HINT: No functio
Cristian Prieto wrote:
mydb=# explain analyze select locid from geoip_block where
'216.230.158.50'::inet between start_block and end_block;
QUERY PLAN
-
David Potts wrote:
Postgress seems to include all this support for geometric types,
lseg,box, etc.
Is there any software for actual printing or displaying database which
has lsex, point types enumerated in it.
I did'nt mange to find any reference to this type of thing on the
current maillist.
Hi.
First: PG version 7.4 and 8.0.
I have a question regarding the following simplified query:
gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
substring
---
SE
(1 row)
The pg docs say that this form of substring uses POSIX re's, and my
understanding of POSIX re
Tom Lane wrote:
Don Isgitt <[EMAIL PROTECTED]> writes:
gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
substring
---
SE
(1 row)
The pg docs say that this form of substring uses POSIX re's, and my
understanding o
Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote:
On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
Thanks, Tom. Interestingly enough, neither my original query or your
Hello,
First, software info:
gds2=# select version();
version
Post
Tom Lane wrote:
Don Isgitt <[EMAIL PROTECTED]> writes:
gds2=# update master set operator=(select
coalesce(newopr,master.operator) from opr_match where state=master.state
and oldopr=master.operator limit 1) where state='NM' and operator is not
null;
I think what y
Bernd Helmle wrote:
Don Isgitt wrote:
Hi,
gds2=# copy survey_match from '/home/djisgitt/perl/fixsvy.dat' with
delimiter as '>';
ERROR: could not open file "/home/djisgitt/perl/fixsvy.dat" for
reading: Permission denied
File sysem permissions are
[EM
Environment: Server running Redhat 3.2.3-20 on quad Xeon 2.4
Postgresql 7.4 compiled from source (gcc 3.2.3)
Application written in Perl (5.8.0) using Tk,
DBI and DBD
Client accessing DB using ODBC (7.03.02) from
Win XP box
Samp
Robert Fitzpatrick wrote:
I have a project where it is necessary to determine Outliers of lab
results and looking for some pointers on the best way to handle this
type of calculation with PostgreSQL. Possibly an operator? I have no
experience with that. I found some info on the web for calculating
Hello,
I have received no posts from GENERAL since yesterday morning; is the
list broken? Thank you.
Don
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMA
Hi list,
Information first:
gds2=# select version();
version
---
Michael Fuhr wrote:
On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote:
gds2=# create function sd(_float8) returns float as '' language 'plr';
CREATE FUNCTION
gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8);
server closed the conne
Adam Witney wrote:
Don Isgitt wrote:
Michael Fuhr wrote:
On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote:
gds2=# create function sd(_float8) returns float as '' language 'plr';
CREATE FUNCTION
gds2=# select round(sd('{1.23,1.31,1.42,1.
Michael Fuhr wrote:
On Wed, Aug 23, 2006 at 08:38:01AM -0500, Don Isgitt wrote:
Thanks for the reply and the research. The relevant file is
[EMAIL PROTECTED] R-2.3.0]$ ls -l $R_HOME/etc/Renviron
-rw-rw-r--1 djisgitt djisgitt 1151 Jun 1 11:42
/home/djisgitt/R-2.3.0/etc/Renviron
Alvaro Herrera wrote:
Don Isgitt wrote:
Michael Fuhr wrote:
On Wed, Aug 23, 2006 at 08:38:01AM -0500, Don Isgitt wrote:
Thanks for the reply and the research. The relevant file is
[EMAIL PROTECTED] R-2.3.0]$ ls -l $R_HOME/etc/Renviron
-rw-rw-r--1 djisgitt djisgitt
17 matches
Mail list logo