"[EMAIL PROTECTED] (Tom Lane)" wrote in comp.databases.postgresql.sql:
[sNip]
> I'm guessing that the big problem is that you didn't measure longitude
> and latitude in identical units in your table, so your "circle" isn't
> real circular, and the smaller problem is that "miles" converts to
> "deg
"[EMAIL PROTECTED] (Tom Lane)" wrote in comp.databases.postgresql.sql:
> "Iain" <[EMAIL PROTECTED]> writes:
>
>> I found this interesting and thought I'd offer it up for comment.
>
> You didn't say what PG version you are using, but I'd venture to bet
> it is pre-7.4.
This must've been
>> Here, this link should help:
>>
>> Search PostgreSQL - Opera
>> http://www.postgresql.org/search.cgi?q=connectby
>
> Thanks...rtfm I know :)
RTFM? Oh, yeah, that's right -- Read The /FUNNY/ Manual! =D
--
Randolf Richardson - [
his avoids having to create a two-column index with a low-selectivity
> column like "month".
Thanks, both of you. I've got some re-thinking to do for this project
I'm working on (since it's a low priority project at the moment, I've got
plenty of time
nice clean and beautiful way?
You're in need of the "CONNECT BY" option which is ideal for scenarios
such as yours. Unfortunately PostgreSQL doesn't have it yet, but I believe
there is a PLSQL script (or something like this) which emulates the CONNECT
BY behaviour and it&#
nd it's called "connectby()"
>> or something like that.
>
> Thanks...Ill look into that.
Here, this link should help:
Search PostgreSQL - Opera
http://www.postgresql.org/search.cgi?q=connectby
--
Randolf Richardson - [EMAIL
parameter.
Interesting. Although I don't have an immediate need for this, I'm
sure it could be useful when storing the results of multiple queries of this
nature in a temporary table.
--
Randolf Richardson - [EMAIL PROTECTED]
Inter-Corporate Computer & Network Services,
e "lower(foo)". In 7.4
> they're more powerful and you can index expressions other than simple
> function calls.
[sNip]
So an "Expression Index" could, for example, be used to sort alpha-
numeric data in a case-insensitive manner? I just want to make sure I'
eld but only have the index
keep track of the most recent 30 days (and then create a secondary index for
all dates) so as to improve performance on more heavily loaded systems.
Am I understanding this new terminology correctly? Thanks in advance.
--
Randolf Richardson - [EMAIL PRO
s, while there are others that see very little activity at all.
Anyway, don't worry, this place is active in a healthy way.
--
Randolf Richardson - [EMAIL PROTECTED]
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/
This messa
indexing to handle this
efficiently. Do you happen to know if PostgreSQL will have a special
indexing option for this feature? If it does, it will very likely provide a
major performance advantage over Oracle.
--
Randolf Richardson - [EMAIL PROTECTED]
Inter-Corporate Computer & Network S
l.html
--
Randolf Richardson - [EMAIL PROTECTED]
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/
This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.
---(end of
d one too by the looks of it -- thanks for sharing
this information); if I start my query from an item at level 5, will the
level be reflected as such, or will it dynamically start at 1?
As I understand it, in Oracle the level would begin at 1 in this case.
Thanks in advance.
--
upport/PostgreSQL/tutorial/
("Arrays" are listed near the end of the page)
In Google.Com, you can also use the following search string:
+postgresql +arrays +tutorial
--
Randolf Richardson - [EMAIL PROTECTED]
Inter-Corporate Computer & N
14 matches
Mail list logo
