Michael Fuhr wrote:
You refer to shs.city. in the select list, but in the from
clause you've aliased shs.city to city. As the SELECT documentation
says,
When an alias is provided, it completely hides the actual name
of the table or function; for example given FROM foo AS f, the
remainder
On Mon, Nov 21, 2005 at 01:56:38AM +0100, Geert Jansen wrote:
> I'm experiencing some weird results with SELECT queries when I recently
> switched to using schemas. Basically, the same query works OK when I set
> my search_path to include the schema, but it doesn't when I qualify the
> tables in
On Mon, 21 Nov 2005, Geert Jansen wrote:
> I'm experiencing some weird results with SELECT queries when I recently
> switched to using schemas. Basically, the same query works OK when I set
> my search_path to include the schema, but it doesn't when I qualify the
> tables in my query.
>
> One quer
Hi,
I'm experiencing some weird results with SELECT queries when I recently
switched to using schemas. Basically, the same query works OK when I set
my search_path to include the schema, but it doesn't when I qualify the
tables in my query.
One query that demonstrates the behaviour is (apolo
