Home » U++ Library support » U++ SQL » Postgresql - execpt vs minus
Postgresql - execpt vs minus [message #22969] |
Thu, 03 September 2009 11:57 |
Zbych
Messages: 325 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: Fri Apr 19 13:57:10 CEST 2024
Total time taken to generate the page: 0.06190 seconds
|