ticklers.RelatedId
> > WHERE tasks.Id = '123456';
> >
> > (I've cleaned it up so it's easier to read.)
>
> Thanks Ryan - that always makes it easier.
It actually looked so much less crazy after the cleaning that I nearly
decided not to ask about
of thousands of rows,
is a nested join really the best way to approach this?
Thanks!
Ryan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of A. Kretschmer
Sent: Friday, October 31, 2008 1:49 AM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Date Index
am Thu, dem 30.10.2008, um 14:49:16 -0600 mailte Ryan Hansen folgendes:
> Hey all,
>
>
>
Hey all,
I'm apparently too lazy to figure this out on my own so maybe one of you can
just make it easy on me. J
I want to index a timestamp field but I only want the index to include the
-mm-dd portion of the date, not the time. I figure this would be where
the "expression" portion
Greetings,
I couldn't find anything about this in the documentation or the mailing list
archives, so forgive me if this has already been addressed.
I'm trying to determine if the full text indexing has any built-in
capability for providing information about word occurrence, i.e. the numbe
I would like to know if this is actually the correct way to search for this
word? The use of brackets isn't documented anywhere that I can find so I'm not
sure if it is even doing what I want it to do or if the correct result is just
a coincidence.
Thanks,
Ryan
--
Sent via pgs
ch blocks table, how do you search it? Do you
perform
twelve separate queries or can you just do one?
Ryan
Ryan Wallace wrote:
>
> UPDATE pgweb SET textsearchable_index_col =
> to_tsvector('english', coalesce(title,'') || coalesce(body,''));
> WH
ndex_col @@ to_tsquery('create & table')
ORDER BY last_mod_date DESC LIMIT 10;
Using this approach. Is there any way of retrieving which of the original
two columns the match was found in?
Any help would be much appreciated,
Ryan
.
Cheers,
Ryan
tables). Any ideas, suggestions
or general pointers would be greatly appreciated.
Thanks very much,
Ryan
hello everyone,
I am trying to run the proc below but get an error : invalid input
syntax for type bigint: "2004-10-26" Can anyone suggest what I am
doing wrong here?
Rx
-- Function: public.getdateallocated(date, date)
DROP FUNCTION public.getdateallocated(date, date);
CREATE OR REPLACE FUNCTI
ase help.
Kind Regards,
-Ryan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 5:57 AM
To: [EMAIL PROTECTED]
Subject: Re: [SQL] Order by MM DD in reverse chrono order trouble
Hello,
I'd love to
Y DEFINER;
***
I removed the use of quote_literal() and had to put parenthesis around the
criteria of the WHERE clause. hrmmm... why is this? does anyone know why
it was giving me an error (s
scaping the single-quotes very confusing and
so far, frustrating. In addition to helping me with this problem, if anyone
can give me some good advice / general guidelines to using strings in my
functions, it will be greatly appreciated since I anticipate writing a lot
of these soon; it
ext)
Foreign Key constraints: $1 FOREIGN KEY (package_id) REFERENCES
packages(package_id) ON UPDATE CASCADE ON DELETE RESTRICT
I must be a total space case today because I can't hammer out the sql to
get a listing of all the packages with a count() of the package_log by
package_id.
Thank
> Ryan wrote:
>> I'm doing some work with part diagrams and server-side image maps. I
>> want to store single point coordinates (x,y) for reference numbers in
>> a table looking like:
>>
>> reference_number text,
>> x int,
>> y int
>>
>&g
are you joe celko, guy who wrote those sql books?
"--CELKO--" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> >> The table at hand is more a kind of a collection of graphs where I
> want to find all possible paths between a given starting point and a
> given en
t; section of my sql
statement is costing me at least 10-20 seconds of execution time. I am
looking for a solution that will speed this up. Does anyone have any advice.
Thanks in advance.
Ryan
PS. Here are the respective execution plans:
Merge Join (cost=0.00..3463985.82 rows=4342404 width=2
I received this bug on a project I administer that Isn't related to my
project. I forwarded it here to see if any of you could help this
person.
[EMAIL PROTECTED] wrote:
>
> Title: reference error when using inherited tables
> Bug Type: Software bug
> Severity: Serious
> Software Versio
and to die is gain."|
| --- Philippians 1:21 (KJV) |
---
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---
ey are of use. TTYL.
---
| "For to me to live is Christ, and to die is gain." |
|--- Philippians 1:21 (KJV) |
---
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---
Chris Ryan wrote:
>
> Craig May wrote:
> >
> > Could someone send me a quick example of a trigger.
>
> Hope this helps.
>
> Chris Ryan
>
-- snipped code --
I am so sorry but you may have noticed my email client wrapped lines it
shouldn't have. I have at
Craig May wrote:
>
> Could someone send me a quick example of a trigger.
Hope this helps.
Chris Ryan
<<< Clip below and execute to create example >>>
--
-- FUNCTION: trigger_last_updated
--
-- DESCRIPTION:
-- This is a function called by the table triggers to update t
Try "SELECT prosrc FROM pg_proc WHERE proname = 'funcname'", where funcname
is the name of the function you want to see.
- Original Message -
From: "stuart" <[EMAIL PROTECTED]>
To: "PG-SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 3:20 AM
Subject: Fw: [SQL] Viewing a function
Does it have to be in one row?
Otherwise, assuming that person_data.d_person_id references person.a_id and
person_data.d_attribute_id references person_attribute.a_id:
select a.a_name from person p, person_data d, person_attribute a where
p.p_name = 'UserYou'reLookingFor' AND p.p_id = d.d_person
Tom Lane wrote:
> Ryan Bradetich <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Ryan Bradetich <[EMAIL PROTECTED]> writes:
> >>>> -- dumping out the contents of Table 'medusa'
> >>>> FATAL 1: Memory exhausted in Allo
Tom Lane wrote:
> Ryan Bradetich <[EMAIL PROTECTED]> writes:
> > -- dumping out the contents of Table 'medusa'
> > FATAL 1: Memory exhausted in AllocSetAlloc()
> > PQendcopy: resetting connection
> > SQL query to dump the contents of Table 'medus
procman, exiting
procman=# select version();
version
---
PostgreSQL 7.0.0 on hppa2.0w-hp-hpux11.00, compiled by gcc 2.95.2
(1 row)
Thanks,
- Ryan
s in this case
I hit a question that fell through the cracks before making it into the
FAQ.
Once again, thanks for everyone's help.
---
| "For to me to live is Christ, and to die is gain."|
| --- Philippians 1:21 (KJV) |
---
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---
--- Philippians 1:21 (KJV) |
---
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---
Tom Lane wrote:
> Ryan Bradetich <[EMAIL PROTECTED]> writes:
> > This worked great! Is their a place I can change the default to 3?
> > I do not want to change all the scripts to include this :)
>
> See src/include/optimizer/cost.h. However, I am currently thinking o
elect count(catagory) from medusa where host_id = 404 and
catagory like 'A%';
count
---
4
(1 row)
Thanks again everyone for all the help! Now that I am finished with school
for the semester,
I should have time to make contributions again ... :)
Ryan
Tom Lane wrote:
> Ryan Bradetich <[EMAIL PROTECTED]> writes:
> > I am in the process of transitioning from postgreSQL 6.5.3 to
> > postgreSQL 7.0. I ran into an issue where a sequential scan
> > is being choosen on postgreSQL 7.0 where an index scan was
>
if not .. please correct me :)
I do not understand why the planner would choose a seqscan over the
index scan because
6704/4,630,229 is ~ 0.15%.
Thanks for your time,
Ryan
- Ryan
34 matches
Mail list logo
