Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Select from two temporary tables
Re: Select from two temporary tables [message #39300 is a reply to message #38078] Mon, 11 March 2013 08:53 Go to previous messageGo to previous message
Zbych is currently offline  Zbych
Messages: 326
Registered: July 2009
Senior Member
Hi,

Mirek, I just want to remind you that AsTable still has wrong postgres syntax:

Current syntax:
select COLUMN from ((select COLUMN from TABLE1) as TABLE2)

Correct syntax:
select COLUMN from (select COLUMN from TABLE1) as TABLE2


Fix:
SqlSet SqlSelect::AsTable(const SqlId& tab) const
{
	StringBuffer t;
	t << SqlCase(MSSQL|PGSQL, "")("(") //<---PGSQL added
	<< "(" << text << ") as \t" << tab.ToString() << '\t'
	<< SqlCase(MSSQL|PGSQL, "")(")");  //<---PGSQL added
	return SqlSet(String(t), SqlSet::HIGH);
}

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Sqlite DB readonly
Next Topic: Some unexpected differences between Sqlite3 and MySql in Upp
Goto Forum:
  


Current Time: Sun May 12 23:53:13 CEST 2024

Total time taken to generate the page: 0.02307 seconds