U++ framework: U++ SQL » Postgresql

Home » U++ Library support » U++ SQL » Postgresql - execpt vs minus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Postgresql - execpt vs minus [message #22969]

Thu, 03 September 2009 11:57

Zbych
Messages: 332
Registered: July 2009

Senior Member

Hi,

Postgresql uses "except" not "minus", so SqlSet operator- and SqlSelect::operator-= should be modified:

SqlSelect& SqlSelect::operator-=(const SqlSelect& s2) {
	text << SqlCase(PGSQL," except (")(" minus (") << s2.text << ')';
	return *this;
}

SqlSet operator-(const SqlSet& s1, const SqlSet& s2) {
	if(s1.IsEmpty() || s2.IsEmpty())
		return s1;
	return SqlSet(s1() + SqlCase(MSSQL|PGSQL, " except ")(" minus ") + s2(), SqlSet::SETOP);
}

Report message to a moderator