Skip site navigation (1) Skip section navigation (2)

BETWEEN SYMMETRIC

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: BETWEEN SYMMETRIC
Date: 2002-06-27 10:31:10
Message-ID: 028f01c21dc5$c20a8f70$0200a8c0@SOL (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

Based on recent discussion, I went thru and got together the work I'd done
on the BETWEEN node.  It's not as far along as I thought.  I ran into a few
hurdles:

* ExecEvalBetweenExpr is probably beyond my powers - I've done my best and
marked my hopelessness with '@@' symbols.  I don't know how to actually
evaluate the node properly, I don't know how to check that all the 3 types
are coercible to the same type and I don't know how to make it take rowvars
(sic?)instead of scalars, as per spec.

Copy and Equal are done, I think.

Out I've guessed at how to do it based on other examples, but I need
feedback.  Read I haven't done at all cos I don't quite understand when/why
it's used or how to do it.

The grammar has been updated to use the new BetweenExpr node, with new
syntax options.

The new keywords have been added in the relevant places, and they are
reserved.

nodes.h and parsenodes.h are aware of the new node.

I have added a full regression test that I used in my old gram.y only
implementation, that didn't use a new node - it will be helpful!

Where do we go from here?

Chris


Attachment: between.diff.txt
Description: text/plain (19.7 KB)

Responses

pgsql-hackers by date

Next:From: Curt SampsonDate: 2002-06-27 10:45:23
Subject: Re: Why I like partial solutions
Previous:From: Jeroen T. VermeulenDate: 2002-06-27 10:05:21
Subject: Case sensitive searches

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group