Home » U++ Library support » U++ SQL » Postgresql - execpt vs minus
Postgresql - execpt vs minus [message #22969] |
Thu, 03 September 2009 11:57  |
Zbych
Messages: 327 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);
}
|
|
|
|
Goto Forum:
Current Time: Wed Jul 02 06:17:38 CEST 2025
Total time taken to generate the page: 0.03471 seconds
|