<[EMAIL PROTECTED]> writes:
> I have PostgreSQL v7.02 in RedHat 6.2;
>
> I have problem with is Query:
> select name, 'user' as class from smuser u=
> nion=20
> select name, 'group' as class from smgroup order by class;
>
Please turn off HTML mail :-(
The problem is with the nonspecific-typ
On Mon, 8 Jan 2001 15:50:42 -0400, <[EMAIL PROTECTED]> wrote:
> I have PostgreSQL v7.02 in RedHat 6.2;
>
> I have problem with is Query:
> select name, 'user' as class from smuser union select name, 'group' as class from
>smgroup order by class;
>
> sentence problem is:{ order by class}
>
I have PostgreSQL v7.02 in RedHat 6.2;
I have problem with is Query:
select name, 'user' as class from smuser union
select name, 'group' as class from smgroup order by class;
sentence problem is:{ order by class}
thank you,
Christian Gonzalez
[EMAIL PROTECTED] writes:
> I have problem with the GROUP BY
But which is it???
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Christian Gonzalez ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Query Problem!!
Long Description
I have problem with the GROUP BY
Sample Code
select name, 'user' as class from smuser union select name, 'group' as class from