Thank you. Later checking showed that these requirements were listed in
the first sentence of the relevant page. Everything works like a champ
now. I've made a small donation to the EFF and to the Red Cross as a
minor thanks for your prompt help.
Kevin Way
---(end of b
On Fri, 14 Sep 2001, Kevin Way wrote:
> I'm having trouble creating a trigger. First i'm creating a function,
> add_to_search in PL/pgSQL.
>
> \df verifies the existance of this function:
> smallint | add_to_search | text, text, text, integer
>
> but when I call:
>
> C
On Sep 14, Kevin Way wrote:
> I'm having trouble creating a trigger. First i'm creating a function,
> add_to_search in PL/pgSQL.
>
> \df verifies the existance of this function:
> smallint | add_to_search | text, text, text, integer
>
-- We can verify all the functio
I'm having trouble creating a trigger. First i'm creating a function,
add_to_search in PL/pgSQL.
\df verifies the existance of this function:
smallint | add_to_search | text, text, text, integer
but when I call:
CREATE TRIGGER item_insert_search_add AFTER INSERT
ON i
Josh Berkus wrote:
> Try putting your sub-selects in the FROM clause instead. (Personally,
> I've never found a use for sub-selects in the SELECT clause)
>
> SELECT j.id, j.created, count(mj.mid), ma1.mcount, ma2.mcount
> FROM j, mj,
> (SELECTjid, COUNT(oid) as mcount FROM ml
>
Josh Berkus wrote:
> Joseph,
>
> The subject line could describe a lot of what I see outside my house
> every day (I live in San Francisco CA).
>
>
>>Could someome explain these error messages to me? Why am I being
>>asked to group by j.id?
>>
>
> Because you've asked the db engine to coun
Esteban Gutierrez Abarzua writes:
> I need to know.. How can I get running query time ?
time psql -c 'query here;'
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 6: Have you searche
Hi I am Esteban from Chile!
I need to know.. How can I get running query time ?
I mean . is there any function?
I hope the answer in english or spanish?
thanks!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
