Alex Pilosov <[EMAIL PROTECTED]> writes:
> Well, I'm on my way to implement what was discussed on list before.
> I am doing it the way Karel and Jan suggested: creating a
> pg_class/pg_attribute tuple[s] for a function that returns a setof.
What? You shouldn't need pg_class entries for function
On Sun, 20 May 2001, Don Baccus wrote:
> At 10:55 AM 5/20/01 -0700, Stephan Szabo wrote:
> > Can the IN always get written as a
> >join and is it always better to do so?
>
> Nope:
> ...
> A better question, I guess, is if it is always better to write
> it as a join if the left hand operand is a
On Sat, 19 May 2001, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > I think what we should probably do is make IN better and use that or then
> > support =ANY(=SOME)/=ALL on such things. I think =ANY would be easy
> > since IN is defined in terms of it in the spec.
>
> And in o
Don Baccus <[EMAIL PROTECTED]> writes:
> BTW Oracle has a 1000-element limit on the number of values in an
> "IN" set.
Yeah? What happens when you get past that?
regards, tom lane
---(end of broadcast)---
TIP 5: Have you c
Stephan Szabo <[EMAIL PROTECTED]> writes:
> I think what we should probably do is make IN better and use that or then
> support =ANY(=SOME)/=ALL on such things. I think =ANY would be easy
> since IN is defined in terms of it in the spec.
And in our code too ;-). ANY/ALL have been there for awhi
Don Baccus <[EMAIL PROTECTED]> writes:
> What's so hard about writing "IN" rather than "=" ???
Even more to the point, if we did adopt such a (crazy IMHO)
interpretation of '=', what makes anyone think that it'd be
any more efficient than IN?
AFAICT, mlw is hoping that redefining '=' would magic
(Machine couldn't find mx record for mohawksoft, replying only
to list)
On Sat, 19 May 2001, mlw wrote:
> Sorry to gripe here. Don't get me wrong, I think Postgres is amazing, and I
> think all you guys do an amazing job.
>
> Is it just me, or do others agree, functions returning sets need to
This is the last post I will make about my text search system, I'll
respond off line if anyone wants to correspond. I have taken up too much
bandwidth as it is. The only reason I have been so persistent is that I
can't believe that I am the only person having this particular problem,
and that some
