In response to Seb :
>
> Thanks to all that responded on and off list. Is it necessary to ensure
> that the "FROM" part of the two queries are exactly the same (the real
No, but both queries should return the same columns (count, typ, order).
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 03
On Wed, 3 Jun 2009 07:04:32 +0200,
"A. Kretschmer" wrote:
> In response to Seb :
>> Hi,
>> Say we have a table:
>> SELECT * FROM weather; city | temp_lo | temp_hi | prcp
>> ---+-+-+--- San Francisco | 46 | 50 |
>> 0.25 San Francisco | 43 | 57 | 0 Hayward | 37 | 5
In response to Seb :
> Hi,
>
> Say we have a table:
>
> SELECT * FROM weather;
> city | temp_lo | temp_hi | prcp
> ---+-+-+---
> San Francisco | 46 | 50 | 0.25
> San Francisco | 43 | 57 |0
> Hayward | 37 | 54
Hi,
Say we have a table:
SELECT * FROM weather;
city | temp_lo | temp_hi | prcp
---+-+-+---
San Francisco | 46 | 50 | 0.25
San Francisco | 43 | 57 |0
Hayward | 37 | 54 |
Hayward | 30 |
