Hi just upgraded to 7.3.2 and imported my db schema
with no probs!
Just wondering... why VOLATILE is being appended to
my functions - can anyone ansewer me what this means? - should i be using joins
instead, does this make a difference? If so an example of this would be much
appreciated!!
C
Peter,
> This does not work because the first select list item references a column
> inside a join, which is not (necessarily) mathematically identical to the
> column that arrives outside of the join and is in the GROUP BY clause.
> (Think of an outer join: the column outside the join might conta
On Sat, 22 Feb 2003, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Fri, 21 Feb 2003, Tom Lane wrote:
> >> Anyone care to offer a gloss on the spec to prove that this behavior
> >> is correct or not correct?
>
> > Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Fri, 21 Feb 2003, Tom Lane wrote:
>> Anyone care to offer a gloss on the spec to prove that this behavior
>> is correct or not correct?
> Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as saying
> that the non natural/using case is separ
On Fri, 21 Feb 2003, Tom Lane wrote:
> Dan Langille <[EMAIL PROTECTED]> writes:
> > This is the query in question:
>
> > SELECT element_id as wle_element_id, COUNT(watch_list_id)
> > FROM watch_list JOIN watch_list_element
> >ON watch_list.id = watch_list_element.watch_list_id
> > WHE
Thank you
i will look into its source code.
and try to find some solution for myself.
regds
mallah.
On Saturday 22 February 2003 07:40 am, Peter Eisentraut wrote:
> Rajesh Kumar Mallah writes:
> > is it possible to get the function creation defination as produced by
> > pg_dump by some SQL q
