Re: [BUGS] Query Problem!!

2001-01-14 Thread Tom Lane
<[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

Re: [BUGS] Query Problem!!

2001-01-14 Thread Yoshihiko Ichikawa
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} >

[BUGS] Query Problem!!

2001-01-14 Thread christiangda
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

Re: [BUGS] Query Problem!!

2001-01-12 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > I have problem with the GROUP BY But which is it??? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[BUGS] Query Problem!!

2001-01-11 Thread pgsql-bugs
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