Changes

Optimizing views in pgSQL

214 bytes added, 13:43, 6 August 2014
no edit summary
</pre>
{{Note|These are Access queries, not pgSQL queries. There is a slightly different syntax. In order to get a working pgSQL query, the [] (square brackets) need to be replaced by "" (double quotes) and the "" (double quotes) in the WHERE clause by '' (single quotes)}}
In this case, it seemed safe to make the according changes, because it is not very likely that another status will be added to the system (and thus the two where clauses are and will stay equivalent). However, this cannot be generalised to other cases.
1,068
edits