>> 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 - [
"[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
"[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
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
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.
--
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
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
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
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
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'
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,
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
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&#
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
14 matches
Mail list logo
