On Sun, Mar 05, 2006 at 11:38:46AM -0800, Stephan Szabo wrote:
> > But imagine instead that this function is more generic. You know
> > that you're trying to get something that's equal to x and equal to
> > y, but you don't know (until the function is called) what those
> > rvalues should be. In
On Sun, Mar 05, 2006 at 01:16:40PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> That would work fine if you said RETURNS SETOF ltree.
>
> That should work too, except that you are trying to return a record
> not an ltree value. Try "RETURN NEXT tree.ltree".
>
> > Because SETOF won't work
On Sun, Mar 05, 2006 at 10:26:35AM -0700, Michael Fuhr wrote:
> On Sun, Mar 05, 2006 at 10:16:52AM -0500, [EMAIL PROTECTED] wrote:
> > I've got one of these:
> >
> > SELECT * from some_table WHERE
> > test_for_equality_is_syntactically_ugly;
> >
> > What I'd like to do is encapsulate the WHERE cl
Hi All,
I've got one of these:
SELECT * from some_table WHERE
test_for_equality_is_syntactically_ugly;
What I'd like to do is encapsulate the WHERE clause in a function,
but I'm having no end of trouble.
The WHERE clause expects the function to return a boolean value. I
can certainly return a
